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
How to create a temporary table in oracle?
What is save point in oracle database?
Why does oracle 9i treat an empty string as null?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
How can I create database in oracle?
How would you change old and new values in an insert, delete and update triggers?
What is Undo Management Advisor in Oracle?
Can group functions be mixed with non-group selection fields?
What is meant by raw datatype?
What are joins, explain all types of joins?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
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
Can you drop an index associated with a unique or primary key constraint?
What is oracle analytical function?
Point the difference between translate and replace?