INSERT ALL INTO TABLE1(COLUMN1, COLUMN2) VALUES('A','B'

what is insert all statement in sql

Question Posted / sudip

2 Answers
6499 Views
CGI, TCS, I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the attributes of the cursor?

995

How to assign a table row to a record variable?

1030

How to enter a new row into a table interactively?

1004

How to drop an index in oracle?

1061

What is oracle update statement with inner join ?

1048

What is a snapshot in oracle database?

1017

Explain view?

1024

Explain alias?

1122

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2246

Is postgres faster than oracle?

1017

what is the dual table in oracle?

987

what is a Nested Loop join?

2103

Is rowid unique in oracle?

994

How to display employee records who gets more salary than the average salary in the department?

1060

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2287