Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Importing Flat Text File into Oracle

Status
Not open for further replies.

codehead

Programmer
Aug 25, 1999
96
US
Hello,<br>
<br>
I need to append a flat text file into an existing Oracle table. The data would be going into two columns. Can I do this with SQL or will I need to use PL/SQL? Any coding help will be appreciated.<br>
<br>
TIA,<br>
<br>
Bob
 
Bob,<br>
<br>
SQLLDR (SQL Loader) would be a good choice here for loading rows into a table from a text file. This is a standard Oracle utility and is quite easy to configure from the documentation.<br>
<br>
Drop us a line again if you have problems with it and I'll dig up my previous efforts to give you a head start.<br>
<br>
Mike<br>
---<br>
Mike_Lacey@Cargill.Com<br>

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top