Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Bonediggler1

    Search All Tables for a Value

    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...
  2. Bonediggler1

    Search All Tables for a Value

    Should be varchar(80)
  3. Bonediggler1

    Search All Tables for a Value

    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.
  4. Bonediggler1

    Subtotals

    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!!
  5. Bonediggler1

    Oracle Variables

    Thanks Dell. This works great~
  6. Bonediggler1

    Oracle Variables

    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...
  7. Bonediggler1

    Date Formatting Discrepencies between Table and Query

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

    Date Formatting Discrepencies between Table and Query

    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...
  9. Bonediggler1

    Date Formatting Discrepencies between Table and Query

    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...
  10. Bonediggler1

    Update Recordset and Export to Report

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

    Update Recordset and Export to Report

    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...
  12. Bonediggler1

    Update Recordset and Export to Report

    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...
  13. Bonediggler1

    Reformatting SQL for Report

    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.
  14. Bonediggler1

    Reformatting SQL for Report

    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...
  15. Bonediggler1

    Build Multi Part String Based on Multiple Variables

    Correct again...thank you!
  16. Bonediggler1

    Build Multi Part String Based on Multiple Variables

    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...
  17. Bonediggler1

    Build Multi Part String Based on Multiple Variables

    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...
  18. Bonediggler1

    Build Multi Part String Based on Multiple Variables

    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...
  19. Bonediggler1

    Build Multi Part String Based on Multiple Variables

    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 '...
  20. Bonediggler1

    Build Multi Part String Based on Multiple Variables

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

Part and Inventory Search

Back
Top