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 John Tel 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: kevina555
  • Content: Threads
  • Order by date
  1. kevina555

    Trigger with SQL Loader

    Hi All, I have a Normalization situation. I have denormalized data in the incoming flat file and has to be normalized into the target, while generating PK as well. But SQL Loader only allows us to create a sequence. Can I use a trigger to tell SQL Loader that if (field x in the record just...
  2. kevina555

    DECODE in SQL LDR control file

    Hi, I need to decode an incoming value from the delimited file and insert the decoded value into the target table. For this, I was wondering if I could write a "decode" in the control file itself or if I have to use a Before Insert Row level trigger........ Thank you.
  3. kevina555

    ORA 01858 error in SQL Loader

    Hi All, I'm a new subscriber to this forum, but have been a great admirer and regular visitor. Very Informative. I've now run into a problem while using SQL Loader. I've used this in the past, but never had suchan irritating issue. I'm trying to load a delimited file into Oracle using...

Part and Inventory Search

Back
Top