SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT REC

SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN
WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?

Question Posted / baleshwarpd

1 Answers
4922 Views
ESS, I also Faced
E-Mail Answers

SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE..

Answer / 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

More Oracle General Interview Questions

What is integrity and what is constraint??Explain with example

0 Answers Google,

can you write commit in triggers?

Does oracle partitioning improve performance?

How to delete all rows a table in oracle?

How to use in conditions in oracle?

How can we create the complete backup of data in the oracle.

0 Answers IPEC, Satyam, SunTec,

What is a partition in oracle?

Write query to fetch second maximum salary from employee table.

4 Answers Bravura Solutions, HCL,

What is a subquery?

What types of joins are used in writing subqueries?

what is IDE,DMV in sql server?

If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?

For more Oracle General Interview Questions Click Here

Categories

Oracle General (1808)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)
Oracle Security (38)
Oracle Forms Reports (510)
Oracle Data Integrator (ODI) (120)
Oracle ETL (15)
Oracle RAC (93)
Oracle D2K (72)
Oracle AllOther (241)