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
- 10431 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 do you understand by database schema and what does it hold?
what is Single Byte Overhead...?
What happens to the data files if a tablespace is dropped?
How to select some columns from a table in oracle?
How index is implemented in oracle database?
What is set verify off in oracle?
What is dual table oracle?
What is Virtual Private Database in Oracle?
Explain the use of consistent option in exp command.
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
Explain about functional dependency and its relation with table design?
How to write a left outer join with the where clause in oracle?
What are the roles of dba?
How do I find the database name in oracle?
Explain the use of grant option in exp command.
