Create a flat file with the this_value amd that values in it. Then use either sqlldr or externale tables to load into your other table.

-----Original Message-----
From: Dave [mailto:oracledba-ezmlmshield-x64263233.[Email address protected]
Sent: Monday, October 08, 2007 4:47 PM
To: LazyDBA Discussion
Subject: Creating multiple rows at once

This one will be easy for you guys.
How do I insert a bunch of data all at once?
Instead of this:

INSERT INTO table name
VALUES ('value this', 'value that');

[and then do it again for the next row]

INSERT INTO table name
VALUES ('value this', 'value that');

How do I just keep going before executing?
Like this:

INSERT INTO table name
VALUES ('value this', 'value that') ('value this', 'value that') ('value this', 'value that') ('value this', 'value that') ('value this', 'value that');




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To unsubscribe: http://www.lazydba.com/unsubscribe.html




Oracle LazyDBA home page