Interested to Buy Any Domain ? << Click Here >> for more details...
what is insert all statement in sql
- 2 Answers
- 6515 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 select some columns from a table in oracle?
What are advantages fo Stored Procedures?
HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?
How to speed up webrick?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
How to use like conditions in oracle?
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.
what is dynamic SGA and static SGA
List the types of joins used in writing subqueries?
How to handle a single quote in oracle sql?
Do View contain Data ?
Oracle General 
