How to load comma delimited data from a file into a Oracle table using SQL PLus

  • Hi,

    I have a data.csv file with data like

    123,john,texas

    342,peter,china

    111,craig,detroit

    I need to insert these values from the file into a table

    create table myTable(id varchar(5),name varchar(5),place varchar(5) )

    Im using SQL plus with Oracle 9i client

    I can't use the sqlldr command as i dont have SQL*Loader

    Pls let me know how to go abt this.

    Thanks

    Roy

  • You can't do this with SQL plus, but what you could try is linking the Oracle database to SQL Server then doing a bulk insert from query analyser.

  • Initially i didn know that sqlldr.exe will be present in the bin folder of the Oracle client:)

    Now am able to import files using sqlldr in the windows command prompt..

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply