Populating Record Number in SQL * LOADER

If you need to populate the sequence of records as they appear in the data file. SQL Loader doesn't necessarily insert data the way it comes in datafile, using RECNUM can help.

Record_ID RECNUM