Interested to Buy Any Domain ? << Click Here >> for more details...
Ho to insert no. of records at a time..i mean i want to
insert 100 records at a time into a table
- 5 Answers
- 10647 Views
- I also Faced
- E-Mail Answers
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
What is a snapshot in oracle database?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
What is a cursor and what are the steps need to be taken?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
What is a static data dictionary in oracle?
What is transport network substrate (tns) in oracle?
How many types of table in Oracle?
How to drop an index in oracle?
What is index in Oracle?
IS it possible to built the oracle database without setting the kernal parameters?
How to view the data files in the current database?
How would you change old and new values in an insert, delete and update triggers?
How to run queries on external tables?
How to create id with auto_increment on oracle?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
