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

which is best insttute for teradata,sybase,mysql,oracle in hyderabad

1 Answers

What is the difference between truncate & delete command?

0 Answers

I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????

1 Answers

What are dml statements in oracle?

0 Answers

Which is faster join or subquery in oracle?

0 Answers

What are a collation and state the different types of collation sensitivity?

0 Answers

difference between truncate and delete ,drop?

3 Answers

What types of joins are used in writing subqueries?

0 Answers

Why is oracle database so popular?

0 Answers

Can anyone give me information about oracle certification

1 Answers

how can we write trigger in trigger???????? can we write one trigger on two table???

2 Answers Value Labs,

What are the system predefined user roles?

0 Answers

For more Oracle General Interview Questions Click Here