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 / raghavendra
insert into table 1 value (select * from table2 where
rownum<101 )
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
What are joins, explain all types of joins?
How to export data with a field delimiter?
What is an external table?
How to convert numbers to characters in oracle?
How to write numeric literals in oracle?
Why does for update in oracle 8 cause an ora-01002 error?
What is redo log?
How to select an oracle system id (sid)?
How to use subqueries in the from clause in oracle?
What is literal?
Describe an oracle table?
How many categories of data types?
What is integrity and what is constraint??Explain with example
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
What are the parameters that we can pass through a stored procedure?