Sequence and Sqlldr

[badrinathn]

Hi,

I have a requirement, where in a sequence number has to be attached to the record to be loaded when using sqlldr.
This is because this sequence number acts as a primary key value and later makes multiple entries in different tables.

Badrinath

[jdjoshi]

Try the following code :

...............
INTO TABLE my_table
(
column_name "sequence_name.NEXTVAL",
......
...
)

I have used it and it works.

Happy coding.