Ho to insert no. of records at a time..i mean i want to
insert 100 records at a time into a table
Answer Posted / selvaraj v
In oracle 10g :
---------------->
Step 1 : SQL> CREATE TABLE identity( ID NUMBER);
Step2 : Write a Simple Procedure for to insert values into
table.
DECLARE
i NUMBER;
BEGIN
FOR i IN 1..100 LOOP
INSERT INTO identity VALUES(i);
END LOOP;
END;
/
PL/SQL procedure successfully completed.
Step 3 : SELECT COUNT(*) FROM identity;
COUNT(*)
----------
100
Please check it. Works fine.
PL/SQL procedure successfully completed.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to turn on or off recycle bin for the instance?
What is oracle join syntax?
How would you change old and new values in an insert, delete and update triggers?
What is a connect identifier?
What is the sid in oracle?
What is hot backup and logical backup?
How to apply filtering criteria at group level in oracle?
What is oracle server autotrace in oracle?
What are the predefined tablespaces in a database?
How to get a create statement for an existing table?
What are the different windows events activated at runtime ?
How to get execution path reports on query statements?
What is a dynamic performance view in oracle?
How to delete a column in an existing table in oracle?
How to do paging with oracle?