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

In article <815575836.13915_at_vnvi.demon.co.uk>, Nigel J Underwood <nigel_at_vnvi.demon.co.uk> wrote:
>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;",

a sql string may prevent you from using direct load mode. if that's true you can revert to using your sequence(count) or sequence(max) idea, for without direct you won't be parallel either.

--
dave