Nii Moi wrote:As Hoek said, you can create an external table, based on your csv file.
thanks for your concern but let me explain the once more what i meant was
i have a table in my database which already might have some data, no i want to merge data from a .csv file into that same table
Nii Moi wrote:First question you need to answer is file location. Is file accessible from database server side of only from client side. Answer to this defines set of tools you can use. If file is accessible from client side only your best bet is SQL*Loader. You create control file and use it to load csv file data into your table. If file is accessible from database server side your best bet is external table plus insert into your table. Both SQL*Loader and external tables are well documented so read Oracle docs. And there are plenty SQL*Loader & external table examples on this forum and on the net.
thank You all for ur concern but it seems the link elaborates more on extracting data into csv file than extracting from csv. what i want to do now is to extract from a csv file into a table