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
- 9109 Views
- I also Faced
- E-Mail Answers
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 is the scenario where you take the database to NoArchivelog mode?
What is where clause in oracle?
What are the different types of failures that occur in Oracle database?
Why do we need integrity constraints in a database?
Explain temporal data types in oracle
Can sub procedure/function be called recursively?
What is ASM (Automatic Storage Management) in Oracle?
what is the use of system.effective.date variable in oracle?
Explain the use of record length option in exp command.
How to write a query with a right outer join in oracle?
How to check your oracle database 10g xe installation?
What is proxy method?
How to use subqueries in the from clause in oracle?
What is SQL access advisor in Oracle?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
