Answer Posted / 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 |
Post New Answer View All Answers
How do you store pictures in a database?
What is a trace file and how is it created in oracle?
Can we convert a date to char in oracle and if so, what would be the syntax?
why dont we assign not null constraint as table level constraint.
What happens to the indexes if a table is recovered?
Difference between pre-select and pre-query
Why packages are used in oracle?
Explain enable novalidate constraint.
What is an oracle recycle bin?
How to write a query with an inner join in oracle?
How to store only time; not date and time?
What is query image?
what is the difference between restoring and recovering?
What is tns name?
Is oracle the best database?
