Interested to Buy Any Domain ? << Click Here >> for more details...
what is insert all statement in sql
- 2 Answers
- 6519 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 the difference between alert log file and tarce file ?
What is the order of defining local variables and sub procedures/functions?
Respected sir, Please send me technical questions related to oracle apps..
Explain what does a control file contain?
various types of hints and their usage
What is the relationship among database, tablespace and data file?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
What is a connect identifier?
How to insert a record into a table?
How to build data dictionary view an new database?
What is a Sequence ?
find the second highest salary of the emp table
Oracle General 
