Answer Posted / 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 |
Post New Answer View All Answers
Can we convert a date to char in oracle and if so, what would be the syntax?
What is the fastest query method to fetch data from the table?
Where do you use decode and case statements?
How to delete multiple rows from a table in oracle?
How do I recompile a procedure in oracle?
How do you bind variables in oracle?
How to create lov dynamically at runtime & attach to text field?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
what is the difference between substr and instr function in oracle?
Why do we use coalesce function in oracle?
Does facebook use oracle?
What is a procedure in oracle?
what is dynamic SGA and static SGA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
