what is insert all statement in sql
- 2 Answers
- 5713 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 |
How to write date and time literals in oracle?
How many types of table in Oracle?
Can a primary key contain more than one columns?
what is integrity constrains?
How are extents allocated to a segment?
How to update values in a table in oracle?
What are the different pseudo commands? Explain in general?
What happens in oracle commit?
Please explain oracle data types with examples?
In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?
What is recycle bin in Oracle?
what is index?
Oracle General 
