Home » SQL & PL/SQL » SQL & PL/SQL » Stored procdure for taking flat files data and storing in oracle table (Oracle 9i)
Stored procdure for taking flat files data and storing in oracle table [message #315180] Sat, 19 April 2008 14:24 Go to next message
bobj123
Messages: 2
Registered: April 2008
Junior Member
Hi,

I have datafiles with txt format i want to insert the data into table in oracle using stored procedure. Can any body help me out in this as i am new to this stored procedures concepts.

Thanks
Re: Stored procdure for taking flat files data and storing in oracle table [message #315182 is a reply to message #315180] Sat, 19 April 2008 14:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why do you think it is a PL/SQL Expert question?
Did you answer "yes" to the 3 questions asked at Not an EXPERT? Post in the NEWBIES forum, NOT here?

Regards
Michel
Re: Stored procdure for taking flat files data and storing in oracle table [message #315196 is a reply to message #315180] Sat, 19 April 2008 17:36 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
You always & ONLY ever insert data into a table using INSERT SQL statement; regardless of what, if anything, may be wrapped around INSERT statement.

[Updated on: Sat, 19 April 2008 17:40] by Moderator

Report message to a moderator

Previous Topic: question on CURSOR
Next Topic: SQL using Aggregate COUNT
Goto Forum:
  


Current Time: Sat Dec 10 16:37:14 CST 2016

Total time taken to generate the page: 0.24320 seconds