Interested to Buy Any Domain ? << Click Here >> for more details...
what is insert all statement in sql
- 2 Answers
- 6529 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 do you mean by merge in oracle and how can we merge two tables?
What is a recycle bin in oracle?
How to use "for" statements in oracle?
What is a dynamic performance view in oracle?
How to see free space of each tablespace?
how to select second mauximum value in a given table under salary column
In Oracle 10g, "g" Stands for what?
Explain the use of owner option in exp command.
What are the set operators union, union all, minus & intersect meant to do?
How many different types of indexes we have in oracle?
24 Answers IBM, TCS,
How to recover a dropped table in oracle?
can you write commit in triggers?
Oracle General 
