Interested to Buy Any Domain ? << Click Here >> for more details...
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 translate command is different from replace?
How to create an oracle database?
How to insert a new row into a table in oracle?
What is system tablespace?
How to login to the server without an instance?
How to convert raw data type into text in oracle? Explain
What are the most common interview questions on ETL Testing for experience?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
What to do if the binary spfile is wrong for the default instance?
What are the uses of synonyms?
20. Using a set operator, display the client number of all clients who have never placed an order.
what are the advantages of running a database in archive log mode?
How to define an oracle sub procedure?
How to start instance with a minimal initialization parameter file?
How to use "startup" command to start default instance?
