Answer Posted / 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 |
Post New Answer View All Answers
Is it possible to insert comments into sql statements return in the data model editor ?
Explain oracle instance.
How will you identify oracle database software release?
Explain a private synonyms?
What is oracle data type?
How many categories of data types in oracle?
How do you find current date and time in oracle?
Why use resource manager in Oracle?
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 many types of segments in Oracle?
What are the common oracle dba tasks?
Give the different types of rollback segments.
How to execute a stored procedure in oracle?
How do I call oracle stored procedures that take no parameters?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?