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
5428 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 object data modeling?

0 Answers

What is difference between UNIQUE constraint and PRIMARY KEY constraint ?

3 Answers

What is ASM (Automatic Storage Management) in Oracle?

0 Answers MCN Solutions,

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

0 Answers GTL,

Briefly explain what is literal? Give an example where it can be used?

0 Answers

How many types of auditing in Oracle?

0 Answers MCN Solutions,

Explain view?

0 Answers

What is an oracle tablespace?

0 Answers

if i am using dml statement in function. then i am writing select statement what was the output

2 Answers MasterCard,

What are the different types of database objects?

0 Answers

Anyone have the Latest Oracle Dumbs?While u have please forard to narain1411@gmail.com

0 Answers

what is cartesian product?

2 Answers

For more Oracle General Interview Questions Click Here