|
|
| Re: how to insert lots of data into a table! [message #372259 is a reply to message #372257] |
Tue, 23 January 2001 06:02  |
John R
Messages: 156
Registered: March 2000
|
Senior Member |
|
|
It depende what you want in the table.
If the data you want can be generated then it's easy to create a plsql block that will step round a loop doing an insert each time, or build up a plsql table and do a bulk insert.
DECLARE
BEGIN
FOR i in 1..20000 LOOP
INSERT INTO table (i,i,i);
END LOOP;
END;
Is this the sort of thing you're looking for?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
