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
How to insert multiple rows with one insert statement in oracle?
What is a sub query? What are its various types?
How to list all indexes in your schema?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
What is bulk copy or bcp in oracle?
How to rebuild an index in oracle?
Explain oracle insert into command?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
When system tablespace is created?
How remove data files before opening a database?
What is a system tablespace?
Can a formula column be obtained through a select statement ?
What are dml statements in oracle?
How do I spool to a csv formatted file using sqlplus?
How to commit the current transaction in oracle?
