Home » SQL & PL/SQL » SQL & PL/SQL » Bulk INsert (Pl/sql)
Bulk INsert [message #359923] Tue, 18 November 2008 18:11 Go to next message
daniel.deepu
Messages: 2
Registered: November 2008
Junior Member
How to bulk insert into a table of two rows and fetching the same data into another table of two rows
Re: Bulk INsert [message #359932 is a reply to message #359923] Tue, 18 November 2008 21:03 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

by Simple SQL of INSERT INTO .... SELECT syntax.

Quote:
INSERT INTO zip_new
SELECT zip_code, state_abbrev, city_name
FROM postal_code;



Smile
Rajuvan.
Re: Bulk INsert [message #359991 is a reply to message #359923] Wed, 19 November 2008 02:47 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Don't use bulk insert/fetch for only two rows. The overhead is bigger than the advantage.
Previous Topic: Join Statement
Next Topic: iterate the select query
Goto Forum:
  


Current Time: Wed Dec 07 12:59:10 CST 2016

Total time taken to generate the page: 0.12169 seconds