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
- 5345 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 will be the syntax to find current date and time in format "yyyy-mm-dd"?
How to create a stored function in oracle?
Which is better Oracle or MS SQL? Why?
What is background process in Oracle?
What are the types of partitions in oracle?
What are the differences between date and timestamp in oracle?
How to create a stored program unit?
Difference between hot backup vs. Cold backup?
Is oracle an operator?
What is the order of defining local variables and sub procedures/functions?
What are the restrictions on external table columns?
How to find out what oracle odbc drivers are installed?
What are triggers in oracle?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
What is the meaning of recursive hints in oracle?
