Home » SQL & PL/SQL » SQL & PL/SQL » simple procedure to load data from flat file into the table
simple procedure to load data from flat file into the table [message #233222] Wed, 25 April 2007 04:13 Go to next message
lokesh.sql
Messages: 9
Registered: November 2006
Location: Pune
Junior Member



Hi All,

Please can i know how to load data from flat file to a table using simple procedure,help will be highly
remembered .

with regards,
Lokesh
Re: simple procedure to load data from flat file into the table [message #233224 is a reply to message #233222] Wed, 25 April 2007 04:18 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Read up about External Tables
Re: simple procedure to load data from flat file into the table [message #233247 is a reply to message #233222] Wed, 25 April 2007 06:30 Go to previous message
martijn
Messages: 283
Registered: December 2006
Location: Netherlands
Senior Member
Or maybe you can use sql-loader:

sqlldr
Previous Topic: using Outlook Calender with PL/SQL
Next Topic: Packages
Goto Forum:
  


Current Time: Wed Dec 07 20:10:41 CST 2016

Total time taken to generate the page: 0.05742 seconds