Home » SQL & PL/SQL » SQL & PL/SQL » Multiple INSERTS
Multiple INSERTS [message #303232] Thu, 28 February 2008 08:34 Go to next message
Messages: 115
Registered: March 2006
Location: London, UK
Senior Member

Hi all, is it possible to do multiple inserts without having to do it as individual INSERT INTO scripts?

I have data in a spreadsheet that I want to insert into a table
and was hoping to convert the xls to a csv, copy and paste into a script with brackets either side of each row..

doesn't seem to like it though.

thanks in advance,
Re: Multiple INSERTS [message #303234 is a reply to message #303232] Thu, 28 February 2008 08:45 Go to previous message
Michel Cadot
Messages: 65090
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use external table or sql*loader.
Many topics of this here.

Previous Topic: problem with where condition including range of date?
Next Topic: nextval and sysdate out of order
Goto Forum:

Current Time: Thu Jul 27 14:16:17 CDT 2017

Total time taken to generate the page: 0.06921 seconds