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
5350 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

after installatio of ORACLE 8i, work properly, but after restarting the system, it throw an error ORA 01034: ORACLE not availble

1 Answers

How to count groups returned with the group by clause in oracle?

0 Answers

I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.

1 Answers IBM, Wipro,

What is null value in oracle?

0 Answers

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

8 Answers IBM,

Please explain oracle left join with an example?

0 Answers

Maximum how many triggers can be updated in table ?

5 Answers Accenture, Cap Gemini,

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

0 Answers

What happens if the update subquery returns multiple rows?

0 Answers

What are the arithmetic operations?

0 Answers

What is a cursor and what are the steps need to be taken?

0 Answers

What is a Data Segment ?

3 Answers

For more Oracle General Interview Questions Click Here