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
- 9084 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
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Difference between open_form and call_form in oracle.
What privilege is needed for a user to connect to oracle server?
How to define a data source name (dsn) in odbc manager?
Explain the difference between sap and oracle?
What are the limitations oracle database 10g xe?
What is the usage of analyze command in oracle?
What privilege is needed for a user to query tables in another schema?
How to update values on multiple rows in oracle?
How to handle a single quote in oracle sql?
Can the query output be sorted by multiple columns in oracle?
What is data block in Oracle?
How to update values in a table in oracle?
How to rename a column in an existing table?
