SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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


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

Author
Message
royston_pledger
royston_pledger
Valued Member
Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)

Group: General Forum Members
Points: 73 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
christine.wilson
christine.wilson
Say Hey Kid
Say Hey Kid (665 reputation)Say Hey Kid (665 reputation)Say Hey Kid (665 reputation)Say Hey Kid (665 reputation)Say Hey Kid (665 reputation)Say Hey Kid (665 reputation)Say Hey Kid (665 reputation)Say Hey Kid (665 reputation)

Group: General Forum Members
Points: 665 Visits: 150
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
royston_pledger
Valued Member
Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)

Group: General Forum Members
Points: 73 Visits: 37
Initially i didn know that sqlldr.exe will be present in the bin folder of the Oracle clientSmile
Now am able to import files using sqlldr in the windows command prompt..
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search