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 are the different types of failures that occur in Oracle database?

838


How to recover a dropped table in oracle?

805


Explain do view contain data?

787


What happens to the current transaction if the session is ended?

820


How to create a table interactively?

756


how to make an oracle object

2103


how can db_files > maxdatafiles since db_files is for instance and the later is for database

2393


State any two functions of oracle?

808


Why oracle is used?

798


How to connect ms access to oracle servers?

741


What is a lookup table in oracle?

746


Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1152


When do I need to use a semicolon vs a slash in oracle sql?

820


What do you mean by a deadlock?

757


How to get the Installed Oracle Version Information ?

859