Re: Can I use user-generated sequences in SQL*Load?

Andy,

You can refer to a sequence in the Loader control file by putting the sequence in quotation marks

e.g.	field1		position(1:20),
	field2		"myseq.nextva;",
	field3.....

Regards

Nigel J Underwood.
VNV International Ltd.

Andy Hardy <AndyHard_at_istel-is.demon.co.uk> wrote:

>Hi,
 

>I'm using sqlload to populate some tables - one of the fields requires
>population with a sequence number generated by a users CREATE SEQUENCE
>statement.
 

>Is there a way of referring to this sequence during the load?
 

>At the moment, I have to perform an update of the table at a later date!
 

>Andy
>--
>Andy Hardy
Received on Sun Nov 05 1995 - 00:00:00 CET