SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN
WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?
- 1 Answers
- 4943 Views
- ESS, I also Faced
- E-Mail Answers
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
How to define a sub function?
What is the difference between substr & instr functions?
What happens to the current transaction if a ddl statement is executed?
What are the uses of Database Trigger ?
How to create a new tablespace in oracle?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
List the types of joins used in writing subqueries?
What is recovery manager(rman) backup in Oracle?
What do you mean by merge in oracle and how can we merge two tables?
how to handle exceptions in post production
Explain the different normalization forms?
What is transport network substrate (tns) in oracle?
What is analyze command used for?
how do u setup a replication site?
is there a tool to trace queries, like profiler for sql server?
