Home » SQL & PL/SQL » SQL & PL/SQL » inserting rows (Oracle 9i)
inserting rows [message #386754] Mon, 16 February 2009 23:10 Go to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
How can we insert 50000 thousand rows into a table using Forall, plese give me entire code?
Re: inserting rows [message #386760 is a reply to message #386754] Mon, 16 February 2009 23:25 Go to previous messageGo to next message
trivendra
Messages: 208
Registered: October 2007
Location: Noida, India
Senior Member
Try this

http://www.oracle.com/technology/sample_code/tech/pl_sql/index.html

Thanks
Trivendra
Re: inserting rows [message #386798 is a reply to message #386754] Tue, 17 February 2009 00:52 Go to previous message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
plese give me entire code?

PL/SQL User's Guide and Reference
Application Developer's Guide - Fundamentals

Regards
Michel
Previous Topic: problem in opening a file (utl_file)
Next Topic: NOT NULL Constraint Oracle SQL
Goto Forum:
  


Current Time: Tue Dec 06 10:36:18 CST 2016

Total time taken to generate the page: 0.09964 seconds