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
- 10673 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 memory advisor in Oracle?
Explain an index?
definition of cluster and non-clustered index?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
Can we store pictures in the database and if so, how it can be done?
Explain a segment?
How to check database size in Oracle?
How to create id with auto_increment on oracle?
When do I need to use a semicolon vs a slash in oracle sql?
How to list all tables in your schema?
How to insert a record into a table?
How to declare a local variable?
Difference between varchar and varchar2 data types?
What is the difference between "as" and "is" in an oracle stored procedure?
What are the set operators union, union all, minus & intersect meant to do?
