SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN
WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?
Answer Posted / manoj
Suppose that the tables are having same structure:
insert into T4 ( select <col1>,<col2>, ...<colN> from T1
UNION select <col1>,<col2>, ...<colN> from T2 UNION select
<col1>,<col2>, ...<colN> from T3)
Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
What are named parameters?
How to view the data files in the current database?
What is an oracle user account?
What is key preserved table?
What is the difference between a user and a schema in oracle?
What is a procedure in oracle?
How to unlock the sample user account in oracle?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
What do you mean by merge in oracle and how can you merge two tables?
How to run the anonymous block again?
How to export data to a csv file?
how can we store any pdf file in oracle
Explain the use of Merge statement in oracle 11g
What are the various constraints used in oracle?
Can multiple cursors being opened at the same time?