Re: Can you use a sequence in SQL*Loader

From: Henk de Wilde <dewildeh_at_xs4all.nl.NOSPAM>
Date: Sat, 02 May 1998 17:03:04 GMT
Message-ID: <354b4f8e.11386471@news.xs4all.nl>

On Sat, 2 May 1998 11:38:08 -0400, "Venkat" <vreddy_at_ix.netcom.com> wrote:

>Hello everyone.
>Is there a way to specify a Sequence in a SQL*Loader control file?. I know
>you can use the SEQUENCE function but I want to know if I can specify a
>specific sequence name.
>
>Thanks in advance
>Venkat
>

You do this by specifying the sequence in a SQL-string. Nothing else is needed in the column specification. For instance :

record_number ":record_number := my_sequence.nextval"

I hope this helps

Henk de Wilde. Received on Sat May 02 1998 - 12:03:04 CDT