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 |
How to select all columns of all rows from a table in oracle?
10. Display the client number, order date and shipping date for all orders where the shipping date is between three and six months after the order date.
Is rowid unique in oracle?
What are the different types of modules in oracle forms?
Which is better Oracle or MS SQL? Why?
What is Private Database Link ?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
Explain about integrity constraint?
Explain an integrity constrains?
What is recovery manager in Oracle?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
what is the syntax of DROP command?