Tags: column, database, extra, file, insert, line, mysql, number, oracle, record, sql, sqlloader, sqlloading, table, target
SQL*Loader - insert record number into table
Anyone know how to insert the record number of the data file line into the target table when SQL*Loading a file ? IE. Table has a extra column called 'record_no', is there anyway to automatically populate this with the data files record number, or does that value have to be in the file already ?
Leave a comment...
- 2 Comments
- RTFM WRT the "SEQUENCE" datatype#1; Tue, 11 Dec 2007 13:49:00 GMT
- Use recnum... Ex:
into Table LOADER_table (
loader_unit Constant 1,
Gregg#2; Tue, 11 Dec 2007 13:50:00 GMT