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
- 10421 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 a snapshot in oracle database?
Explain do view contain data?
List out the components of logical database structure of oracle database.
What is a proxy object?
How to lock and unlock a user account in oracle?
What is the difference between translate and replace in oracle?
What is the difference between view and materialized view in Oracle?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
How to update a table row with a record?
what are steps for interface? where is exchange rate defined in which table?
What is the use of aggregate functions in oracle?
How to run create database statement?
How to execute a stored program unit?
what is the difference between substr and instr function in oracle?
What is a read write transaction in oracle?
