Interested to Buy Any Domain ? << Click Here >> for more details...
what is insert all statement in sql
- 2 Answers
- 6413 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 execute a stored procedure in oracle?
What do database buffers contain?
What is execute immediate in oracle?
How can we create the complete backup of data in the oracle.
0 Answers IPEC, Satyam, SunTec,
what is the dual table in oracle?
How to start an oracle instance?
How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.
What is the maximum number of triggers that can be applied to a single table?
When do you get a .pll extension in oracle? Explain its importance
What is a package ? What are the advantages of package ?
how do get database name at sql prompt?
State all possible different index configurations a table can possibly have?
Oracle General 
