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
Is primary key indexed by default in oracle?
what is port in oracle? how is it related to database application.
please explain.. DB architecture ...
What happens if you lost a data file?
How to update values on multiple rows in oracle?
How to create a stored procedure in oracle?
Explain temporal data types in oracle
How do I uninstall oracle client from windows?
What is a initialization parameter file in oracle?
What is an oracle function?
How to drop a stored procedure in oracle?
What is an oracle user role?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
What is blob datatype?