Interested to Buy Any Domain ? << Click Here >> for more details...
what is insert all statement in sql
- 2 Answers
- 6526 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 database buffers contain?
1.display list of all users from ur data base.what is the query?
What would you use to improve performance on an insert statement that places millions of rows into that table?
How do you bind variables in oracle?
How do we get field details of a table?
How different is ms access and oracle?
Can we create trigger on materialized view in oracle?
How do I limit the number of rows returned by an oracle query after ordering?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
What is a deadlock in SQL? How can you prevent it?
What are the different windows events activated at runtime ?
what are Triggers?
Oracle General 
