Unique sequence number per datafile using SQL Loader

From: <radhika.penagonda_at_gmail.com>
Date: 25 Oct 2006 07:40:26 -0700
Message-ID: <1161787225.980599.313360_at_e3g2000cwe.googlegroups.com>



[Quoted] Here's the requirement:

[Quoted] [Quoted] I have a datafile with say 500 records to be loaded. Each time I load [Quoted] the file, I need to generate a sequence number unique to the file, which means all the 500 records loaded from that file should have the same sequence number.
The next file to be laoded will have another unique number. I thought of using to_number(to_char(sysdate, 'YYYYMMDDHHMMSS') for a unique sequence. however, this does not generate one unique number for a file.

Is there any other way to handle this requirement in the control file itself. Received on Wed Oct 25 2006 - 16:40:26 CEST

Original text of this message