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

Why do you use stored procedures and state some of its disadvantages?

0 Answers

Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.

3 Answers

How to omit columns with default values in insert statement in oracle?

0 Answers

How do I know if oracle is installed on windows?

0 Answers

What to do if the startbd.bat failed to start the xe instance?

0 Answers

State any two functions of oracle?

0 Answers Aricent,

How to experiment a data lock in oracle?

0 Answers

Explain about achiever in sql?

0 Answers

What happens if the imported table already exists?

0 Answers

How to update rows in table, suppose i have lacks of rows in table how to update total table with update statement. Can u please any one answer this question with update statement.

2 Answers

Where are the settings stored for each instance in oracle?

0 Answers

How do I use os authentication with weblogic jdriver for oracle and connection pools?

0 Answers

For more Oracle General Interview Questions Click Here