what is insert all statement in sql
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 |
what is the difference between simple view and complex view?
What are the arithmetic operations?
How to create a new oracle data file?
Explain the types of exception?
What is system tablespace?
what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?
What is meant by joins?
What is coalesce function?
How many types of tables are there in oracle?
What do you mean by a deadlock?
what is a Nested Loop join?
I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.