Recent content by Bonediggler1

This is the code sample: select table_name, column_name from (select rownum, table_name, regexp_substr(dbms_xmlgen.getxml(‘select * from “‘||table_name||’”‘),’<[^>]*>&string</[^<]*>’) column_name from user_tables) where length(column_name)!=0; Enter value for string: email I am...

Should be varchar(80)

Experts- I need some code that will search all tables/fields in a schema for a specific value. The db is relatively small so this isn't a huge issue. Not being very conversant with pl/sql, I cannot get the code I have found elsewhere on the net to work. Thanks in advance for your help.

Hello- I have a query that produces 9 columns, I would like to do a subtotal on the 9th column based on 2 of the returned columns. I cannot get this to work with ROLLUP. Is it even possible? Thank you!!

Thanks Dell. This works great~

Hello- I need to create a report in Crystal with an Oracle back-end and a query that uses unbound variables (:Beg_Date) and (:End_Date). When trying to do this I get the "ORA-01008: not all variables bound" error. Unfortunately I do not have ANY development rights in Oracle - I can only...

Simple answer. TO_DATE(EXPORT_DATE value,'MM/DD/YYYY HH:MI:SS AM') Thanks for helping me think this through!

Thank you Carp To be more specific: 1) Source and destination tables are both the same (TABLE1) 2) EXPORT_DATE in this table is datatype DATE 3) After pulling EXPORT_DATE in format 'MM/DD/YYYY HH:MI:SS PM' and putting it back into the query to get more data from TABLE1 I get the following...

Hello Long story short: 1) I pull field EXPORT_DATE (format DATE) from table TABLE1 which yields '9/10/2011 7:35:10 PM' 2) I need to take this value and plug it into the WHERE clause of another query, but Oracle expects this format: 'DD-MON-YY'. 3) I need to retain the timestamp How do I...

I need this for multiple columns. is this possible with a derived column?

Hi Sorry, I oversimplified the package. Actually I am pulling data from 2 different (heterogeneous) sources and joining via a merge join, then pushing to a recordset. As such, I cannot manipulate the data via SQL/extract via a query. Again, this can be accomplished by throwing everything...

Hello I am trying to do the following via SSIS: 1)Extract data from SQL Server 2)Put this data into a recordset 3)Update the recordset (e.g. if column 1 has value "tomorrow" update it to say "today") 4)Export to Excel I am not having trouble with any of this except #3. Not sure how to update...

This was just an example. Once the conceptual logic is figured out, I would determine a maximum number of transactions per transaction type and number of checks per payment - and use that many fields in the final report, regardless of whether they get populated all the time or not.

Hi- I have a report with a/r data that includes account, invoice #, transaction type, transaction amount, and check #. Every account has multiple invoices, each invoice can have multiple transactions (of different or the same type), and each transaction which is a payment may have a unique...

Correct again...thank you!