Interested to Buy Any Domain ? << Click Here >> for more details...
what is insert all statement in sql
- 2 Answers
- 6615 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 is a server parameter file in oracle?
Shall I get Pro*C Compiler in Oracle-10g release ?
What is open database communication (odbc) in oracle?
How a tablespace is related to data files?
What are the different windows events activated at runtime ?
which is best institue to learn oracle 11i in ameerpet or maithrivanam or sr nagar please help
What is the purpose of a cluster?
How to use null as conditions in oracle?
Differentiate between post-database commit and post-form commit?
What do you understand by a database object?
How to commit the current transaction in oracle?
write a query that displays every Friday in a year with date?
Oracle General 
