Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to load comma delimited data from a file into a Oracle table using SQL PLus Expand / Collapse
Author
Message
Posted Thursday, June 5, 2008 7:10 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, September 12, 2008 1:09 AM
Points: 17, Visits: 37
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
Post #512096
Posted Friday, June 6, 2008 2:21 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 8:44 AM
Points: 509, Visits: 133
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.
Post #512749
Posted Thursday, June 12, 2008 3:19 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, September 12, 2008 1:09 AM
Points: 17, Visits: 37
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..
Post #515738
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse