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
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
How to calculate date and time differences in oracle?
What is backup in Oracle?
How to convert raw data type into text in oracle? Explain
What's dateware house and what's clustor with practicle example
What do you mean by cdb and pdb in oracle 12c?
How to assign values to variables?
Explain an exception?
How to run queries on external tables?
How will you write a query to get a 5th rank student from a table student_report?
How to write a left outer join with the where clause in oracle?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
Is there an oracle sql query that aggregates multiple rows into one row?
What is the recommended interval at which to run statspack snapshots, and why?
When system tablespace is created?
