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

How to import one table back from a dump file?

0 Answers

Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.

4 Answers JPMorgan Chase,

How to create a server parameter file?

0 Answers

Explain the use of record length option in exp command.

0 Answers

What is transport network substrate (tns) in oracle?

0 Answers

How to estimate disk space needed for an export job?

0 Answers

What is rowid and rownum in oracle?

0 Answers

What are the components of logical database structure in oracle database?

0 Answers

What is a cluster?

2 Answers

How to select an oracle system id (sid)?

0 Answers

how to see the data (in unix) using dataset in datastage?

1 Answers iGate,

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

0 Answers

For more Oracle General Interview Questions Click Here