Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ankit
An insert all statement allows you to insert data into
multiple table with a single statement. For example:
INSERT ALL
INTO TABLE1(COLUMN1, COLUMN 2) VALUES('A','B')
INTO TABLE2(COLUMN 3,COLUMN4) VALUES ('1','2')
INTO TABLE3(COLUMN5,COLUMN6) VALUES ('2','A')
FROM DUAL
| Is This Answer Correct ? | 13 Yes | 3 No |
Post New Answer View All Answers
what is reindexing?
How to run queries on external tables?
Explain oracle’s system global area (sga).
What do you mean by merge in oracle?
how to handle exceptions in post production
What is oracle rowcount?
How to connect to the server with user account: sys?
Explain self joins in oracle?
What is the difference between substr & instr functions?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
What is oracle open database communication (odbc)?
How to store only time; not date and time?
What are the differences between number and binary_float in oracle?
How can we delete duplicate rows in a table?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
