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: 63951
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: Fri Oct 28 11:42:17 CDT 2016

Total time taken to generate the page: 0.14302 seconds