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
- 5485 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
what is the difference between substr and instr function in oracle?
Is oracle a programming language?
how do u setup a replication site?
Is it possible to insert comments into sql statements return in the data model editor ?
How to select some rows from a table in oracle?
What is the difference between a hot backup and a cold backup in oracle?
How to retrieve the count of updated rows?
How to load a large xml file?
How can we find out the current date and time in oracle?
What is Data Dictionary Cache in Oracle?
How to use in conditions in oracle?
How to create additional tablespaces for an new database?
How to initialize variables with default values?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
Explain compound trigger in oracle?
