what is insert all statement in sql

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


Please Help Members By Posting Answers For Below Questions

What is connection pooling in oracle?

756


what is the difference between data migration and production migration.

2083


how can we store any pdf file in oracle

1900


How to delete a column in an existing table?

827


How does oracle handle read consistency?

900


Why do we need oracle client?

717


How to define default values for formal parameters?

812


What is truncate oracle?

751


What are the uses of linked server and explain it in detail?

838


I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2113


What are joins, explain all types of joins?

1969


Explain about the analyze command in oracle?

818


How to update a table row with a record?

809


What is backup in Oracle?

793


You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1697