Answer Posted / sudip
INSERT ALL
INTO TABLE1(COLUMN1, COLUMN2) VALUES('A','B')
INTO TABLE2(COLUMN3,COLUMN4) VALUES ('1','2')
INTO TABLE3(COLUMN5,COLUMN6) VALUES ('2','A')
select * FROM DUAL
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What happens to the current transaction if the session is ended?
Is oracle an open source?
How to create a new oracle data file?
How do I connect to oracle database?
How to display employee records who gets more salary than the average salary in the department?
When do you get a .pll extension in oracle?
What would you do with an in-doubt distributed transaction?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What happens if you set the sga too low in oracle?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
 How to use an oracle sequence generator in a mapping?
How to add a new column to an existing table in oracle?
How to get execution path reports on query statements?
How to return top 5 rows in oracle?
How do you store pictures in a database?