Search results for query: *

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!

UPDATE PRICING SET COMMENT = COMMENT + CASE WHEN SUBSTRING(CL_RM_FLAG,2,1) = 'C' AND PHARM_FLAG IS NULL THEN /*Non VA*/ CASE WHEN JURISDICTION_ST <> 'VA' THEN CASE WHEN FEE_W <> '6.75' THEN 'FEE should be $6.75\' ELSE '' END + CASE WHEN (P_FEE_W/NULLIF(P_REDUCTION,0)) NOT...

Sorry to keep this going, but the logic of "SET COMMENT = COMMENT + XYZ" is not working. I broke the logic into blocks as suggested, but each block of logic will overwrite the existing value in the COMMENT field. Is there any way to update an existing value by concatenating it with another...

Yes - the entire process surrounding data for the client in question is an utter mess - and the fields and related validations are in the dozens. I cannot validate data at the source (Oracle) so am doing it via an extract into SQL Server. Regardless, your suggestion to break the updates into...

Let me take a step back - this is a move in the right direction, however when I start putting nested case statements in the logic, it stops working. I.e.: Update Table set comment = comment + Case when field1 <> 10 then ' Field3 != $8' else '' END + Case when field2 <> 5 then '...

Looks like this will do the trick. Thank for the help!