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 assign values to data fields in record variables?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
State and explain about oracle instance?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
What privilege is needed for a user to create views in oracle?
Give the advantages and disadvantages of clusters.
Can we write insert statement in function in oracle?
What is a relational database management system?
what are the mandortary parameters required for cuncurrent program definition in oracle apps R12?
 What are the oracle DML commands possible through an update strategy?
What is oracle rownum?