what is insert all statement in sql
- 2 Answers
- 5934 Views
- CGI, TCS, I also Faced
- E-Mail Answers
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 execute immediate in oracle?
How do I know if oracle client is installed on windows?
what are the different types of cursors? explain?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
How to create an initialization parameter file?
What is RULE-based approach to optimization ?
What to do if dba lost the system password?
What are a query and state the different types of queries and their uses?
how can get like this result table A col1 col2 --- ----- a A b B C C .. .. .. ... .. ... wants result like for a single column col1 ------ a,b,c,........n of data and another is col1 ------- A B C D ........ a b b d ........
How to create index-by table in oracle?
What is redo log?
Oracle General 
