Home » RDBMS Server » Server Administration » reading text file(csv) into a database table
reading text file(csv) into a database table [message #369989] Thu, 23 November 2000 01:10 Go to next message
mahesh kumar
Messages: 4
Registered: November 2000
Junior Member
I want a help on this very urgently. I want to read a text file which is a comma separated file(CSV) and write it into the database also the fastest way bcoz the text file is very huge and the reading process is very frequent. It would be more helpful if there is an example included
Thanks in advance
Mahesh Kumar

Report message to a moderator

Re: reading text file(csv) into a database table [message #369992 is a reply to message #369989] Thu, 23 November 2000 05:04 Go to previous messageGo to next message
John R
Messages: 156
Registered: March 2000
Senior Member
You probably want to use SQLLOADER.

Examples are a bit problematical as it depends entirely on the file layout, but most good Oracle reference books have a section about it.

Report message to a moderator

Re: reading text file(csv) into a database table [message #370005 is a reply to message #369989] Tue, 28 November 2000 00:15 Go to previous message
Hertz
Messages: 2
Registered: November 2000
Junior Member
You can use module UTL_FILE it's the best way then
SQLLOADER. For more information send me a mail.

Report message to a moderator

Previous Topic: Query/Insert in a view
Next Topic: returning only certain rows from a query
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Mar 12 09:20:34 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.