what is insert all statement in sql

Answers were Sorted based on User's Feedback



what is insert all statement in sql..

Answer / ankit

An insert all statement allows you to insert data into
multiple table with a single statement. For example:

INSERT ALL
INTO TABLE1(COLUMN1, COLUMN 2) VALUES('A','B')
INTO TABLE2(COLUMN 3,COLUMN4) VALUES ('1','2')
INTO TABLE3(COLUMN5,COLUMN6) VALUES ('2','A')
FROM DUAL

Is This Answer Correct ?    13 Yes 3 No

what is insert all statement in sql..

Answer / 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

More Oracle General Interview Questions

How to select all columns of all rows from a table in oracle?

0 Answers  


10. Display the client number, order date and shipping date for all orders where the shipping date is between three and six months after the order date.

3 Answers   Wipro,


Is rowid unique in oracle?

0 Answers  


What are the different types of modules in oracle forms?

0 Answers  


Which is better Oracle or MS SQL? Why?

2 Answers   Bally Technologies,


What is Private Database Link ?

1 Answers  


src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

0 Answers   IBM,


Explain about integrity constraint?

0 Answers  


Explain an integrity constrains?

0 Answers  


What is recovery manager in Oracle?

0 Answers   MCN Solutions,


what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

0 Answers  


what is the syntax of DROP command?

10 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)