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

How to define an anonymous procedure with variables?

545


What is a server parameter file in oracle?

594


What is meant by joins?

622


What is oracle rownum?

522


When system tablespace is created?

605






What is flashback in Oracle?

581


How to retrieve data from an explicit cursor?

559


What do you mean by merge in oracle and how can you merge two tables?

522


What is archive log in Oracle?

599


How to start an oracle instance?

574


How to create a new table in your schema?

605


How to empty your oracle recycle bin?

573


What are the built-in functions used for sending Parameters to forms ?

2844


How many data types are supported?

617


What happens in oracle commit?

568