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 data migration and production migration.
How to start a new transaction in oracle?
Differentiate between translate and replace?
what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval
Give the various rollback segment states.
who is the father of oracle and send chodd rules
What is the difference between post-database commit and post-form commit?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
How to import one table back from a dump file?
What is Normalization ?
55 Answers ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault,
how to produce numbers from 1 to 10 using dual table
What is schema?
41 Answers Bodhi Global Services, Cognizant, HCL,