what is insert all statement in sql
- 2 Answers
- 5483 Views
- CGI, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
What are the execution control statements?
Differnce between view and index
What is the fastest query method to fetch data from the table?
structural difference between bitmap and btree index ?
Explain the use of ignore option in imp command.
Oracle
0 Answers ABC, Genpact, HUI, Oracle,
What is flashback Query ? And Use ?
How to pass a cursor variable to a procedure?
What do you know about normalization? Explain in detail?
How to start your 10g xe server?
WHAT IS ecc 6.0
what is difference between foreign key and reference key
Oracle General 
