Interested to Buy Any Domain ? << Click Here >> for more details...
SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN
WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?
- 1 Answers
- 5399 Views
- ESS, I also Faced
- E-Mail Answers
Answer Posted / manoj
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 View All Answers
master table and child table performances and comparisons in Oracle ?
What is data block in Oracle?
Is postgres faster than oracle?
Why oracle is used?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
What are internal user account in oracle?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
How many memory layers are in the oracle shared pool?
How many anonymous blocks can be defined?
What is a system tablespace?
How index is implemented in oracle database?
Why packages are used in oracle?
How to use group functions in the select clause using oracle?
what are bitmap indexes? How does they work?
What privilege is needed for a user to connect to oracle server?
