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
Printable View
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
Try the following code :
...............
INTO TABLE my_table
(
column_name "sequence_name.NEXTVAL",
......
...
)
I have used it and it works.
Happy coding.