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

• royston_pledger

  Ten Centuries

  Points: 1031

  More actions

  June 5, 2008 at 7:10 am

  #183172

  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

• christine.wilson

  Right there with Babe

  Points: 725

  More actions

  June 6, 2008 at 2:21 am

  #825324

  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.

• royston_pledger

  Ten Centuries

  Points: 1031

  More actions

  June 12, 2008 at 3:19 am

  #827712

  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..