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
What are group functions in oracle?
how to clone 9i Database on to 10g Database.
How to empty your oracle recycle bin?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
what is IDE,DMV in sql server?
Explain oracle’s system global area (sga).
Explain the use of control file?
What privilege is needed for a user to connect to oracle server?
How do we represent comments in oracle?
What is a trace file and how is it created in oracle?
How view is different from a table?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
Explain what are the advantages of views?
When do I need to use a semicolon vs a slash in oracle sql?
What are the different oracle database objects?