Home » Developer & Programmer » Forms » Load data from text file to oracle database
Load data from text file to oracle database [message #81043] Mon, 30 December 2002 21:59 Go to next message
soheail
Messages: 8
Registered: December 2002
Junior Member
dear sir,
can you send me a PL/Sql or DDE code for loading data.

soheail

Report message to a moderator

Re: Load data from text file to oracle database [message #81099 is a reply to message #81043] Mon, 06 January 2003 23:46 Go to previous message
bill
Messages: 75
Registered: November 1999
Member
The easiest and fastest way to load data from text files into ur DB is to use SQL Loader.

U need to create a control file for ur sql loader which defines the structure of the text file and a Datafile which actually is the text file containing all the data.

To know how to create a control file for Sql Loader, see Oracle refernce guide.

HTH.
Bill

Report message to a moderator

Previous Topic: ORA-12154 : TNS: Could Not Resolve Service Names
Next Topic: question
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 21:16:02 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.