Generate a continous sequence number across multiple SQL Loader loads
From: <lemee_at_my-deja.com>
Date: Sat, 07 Aug 1999 01:33:11 GMT
Message-ID: <7og2cn$5bu$1_at_nnrp1.deja.com>
[Quoted] I have a large amount of data from multiple files to be loaded into one database. How can I use one sequence to track and insert all this data? Is there any way to set the DEFAULT value to a sequence? The docs say that it can't be done because the columns are "not fully specified." Can I use a sequence that I created for that user?
Date: Sat, 07 Aug 1999 01:33:11 GMT
Message-ID: <7og2cn$5bu$1_at_nnrp1.deja.com>
[Quoted] I have a large amount of data from multiple files to be loaded into one database. How can I use one sequence to track and insert all this data? Is there any way to set the DEFAULT value to a sequence? The docs say that it can't be done because the columns are "not fully specified." Can I use a sequence that I created for that user?
Thanks!!
LeMee
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Sat Aug 07 1999 - 03:33:11 CEST