SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN
WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?
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
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What are a cluster and non-cluster index?
Explain the use of indexes option in exp command.
What is a user role in oracle?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
Explain oracle instance.
can u plz provide me oca sql dumps please i need them
How do I connect to oracle?
What is the difference between primary key and unique key and foreign key in oracle?
How to do clean up if create database failed?
Can we use bind variables in oracle stored procedure?
What is blob datatype?
how to do daily transactions with out sql* loader control file regesterd in apps?