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 gkittelson 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: *

  • Users: btw22
  • Order by date
  1. btw22

    SQL Loader and Dates

    I have following date field (effective_dt)in tab delimited flat file (always populated as:) effective_dt 2001-01-12 2000-02-28 My control file looks like: LOAD DATA INFILE '$HOME/S599_012002_botax.txt' APPEND INTO TABLE BOTAX_HIST FIELDS TERMINATED BY WHITESPACE TRAILING NULLCOLS col 1...
  2. btw22

    What's wrong in: TYPE TYPE_row_cur1 IS RECORD...

    In ref curs def. add return type - also I would declare return type first just to be safe - TYPE TYPE_tbl_cursor IS REF cursor RETURN row_cur1 ;
  3. btw22

    Teradata Data Migration

    Shortly, we will be intergrating large amounts of Teradata data into our Oracle 8i data mart on a monthly basis. I have heard about Oracle's Transparent Gateways - does anyone use this? Is there a better alternative? Thnaks for feedback.

Part and Inventory Search

Back
Top