Home » SQL & PL/SQL » SQL & PL/SQL » flat files......
flat files...... [message #190726] Fri, 01 September 2006 00:29 Go to next message
ramesha.smiley
Messages: 19
Registered: August 2006
Location: Chennai
Junior Member

Hi,

I'm an intermediate in PL/SQL and i'm trying to learn the flat files techniques in PL/SQL.

Can someone educate me as to " how can i insert a flat file into an Oracle table ".

I appreciate an immediate response from anyone and i thank for the same.

regards,
Ramesh
Re: flat files...... [message #190733 is a reply to message #190726] Fri, 01 September 2006 01:13 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
With pure Pl/sql techniques
http://download-east.oracle.com/docs/cd/B19306_01/appdev.102/b14258/u_file.htm#sthref14093
Other widely employed method is to user an external table
or
Tools like sql*loader.

Please search the forum for these.


Previous Topic: Set Numeric Precision when using MViews.
Next Topic: Calls over gateways
Goto Forum:
  


Current Time: Sun Dec 04 20:21:42 CST 2016

Total time taken to generate the page: 0.14749 seconds