Hi,
I've arequirement of loading some data from csv file to a table. BUt at the same time i've to load the serial#. For example, in csv file i've emp_name,salary,designation as john, 8000, consultant. In table i need to load 1,john,8000,consultant. where 1 is serial# and it's autoincreamental. That means in next row it'll be 2,3,4....

How can i do this. Any advice highly appreciated.

Thanks