Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between join and union.
- 27 Answers
- 180564 Views
- 3i Infotech, ABC, Oracle, Polaris, TCS, XT Global, I also Faced
- E-Mail Answers
Answer Posted / kamruddin saha
Join can be implemented different numbers of column where as
Union is implemented same number of column in different tables
Ex:- Table1 Contains 5 column and Table2 contains 8 columns.
So we can get data of 3 columns from Table1 and 4 Columns
from Table2 using JOIN.
But using UNION we can get same number of column from both
table.Like 2 columns from Table1 and 2 columns from Table2.
Thank You
| Is This Answer Correct ? | 13 Yes | 8 No |
Post New Answer View All Answers
What is the difference between left outer join and left join?
What is cascade in sql?
How to take user input in pl sql?
What are different methods to trace the pl/sql code?
What is Materialized View? In What Scenario we Use Materialized View?
Why cross join is used?
What is a unique key?
How many types of triggers exist in pl/sql?
What are the topics in pl sql?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
What is a common use of group by in sql?
Mention what does plv msg allows you to do?
What is memory optimized table?
What does cursor do in sql?
What are analytical functions in sql?
