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
How will you write a query to get a 5th rank student from a table student_report?
Why we use bulk collect in oracle?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
How to create a stored procedure in oracle?
How do I limit the number of oracle database connections generated by weblogic server?
How do I know if oracle client is installed on windows?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What privilege is needed for a user to create views in oracle?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
What are the different editions of oracle?
Can group functions be mixed with non-group selection fields?
How to define an anonymous block?
What is backup in Oracle?
Explain rename?
What is SQL Tuning Advisor in Oracle?