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 / swapna
Example there is a table name emp.It has 100 records
Another table name is dept
Now i want to insert table emp 100 records into dept
--insert into dept select * from emp
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
Explain the importance of .pll extension in oracle?
What are ddl statements in oracle?
How to insert a record into a table?
Why cursor variables are easier to use than cursors?
What are the arithmetic operations?
Which is better Oracle or MS SQL? Why?
What are the ansi data types supported in oracle?
Where is the export dump file located?
How to find out what oracle odbc drivers are installed?
How to define a variable to match a table column data type?
What is oracle database 10g express edition?
How to select some columns from a table in oracle?
What is the database name in oracle?
How to select an oracle system id (sid)?