Generate sequential number while importing text

[Terry Dykstra]

I'm using the text importer to load csv files and I need to automatically create a sequence number. This will allow me at a later point in time to save the data back to a text file in the same order as the original csv file.
Currently I'm using a work around by opening the csv in Excel, adding an extra column with the sequence number, but I really would like to see a 'native' function in PL/SQL Developer to do this.

The other limitation I need to work around is that you must match an import column to a table column, but I would like an option to fill a table column without requiring a corresponding input column.

 

[Marco Kalter]

I have added this to the list of enhancement requests.

For a sequence number you could consider to create a before insert trigger on the table to fill the column from an Oracle Sequence. This way you don't need to use Excel to explicitly create the sequence column data.