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
4580 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..

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 Trigger in Oracle?

0 Answers MCN Solutions,

What is recycle bin in Oracle?

0 Answers MCN Solutions,

You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.

3 Answers Amazon, HCL,

How to write numeric literals in oracle?

0 Answers

What are the uses of synonyms?

0 Answers

When system tablespace is created?

0 Answers

how to find find & delete duplicate rows from two different tables?

3 Answers Accenture, TCS,

How to define Data Block size ?

2 Answers

What are the commands youd issue to show the explain plan for select