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');



Oracle LazyDBA home page