Interested to Buy Any Domain ? << Click Here >> for more details...
tab1 tab2
1,a 1,d
2,b 3,c
perfoms outerjoin what is the o/p?
write sql query for outerjoin?
- 3 Answers
- 8855 Views
- Infotech, I also Faced
- E-Mail Answers
Answer Posted / karthi
select * from tab1 full outer join tab2 on
tab1.key_column=tab2.key_column;
or
select * from tab1,tab2 where tab1.key_column(+)=tab2.key_column
union
select * from tab1,tab2 where
tab1.key_column=tab2.key_column(+);
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
Can you explain engine tier in information server?
What are the benefits of datastage?
What is the difference between datastage and datastage tx?
What are the types of containers?
how to add a new records into source?
What is quality stage?
Where do the datastage jobs get stored?
Can you explain how could anyone drop the index before loading the data in target in datastage?
Why do you need stage variables?
how to write server Routine coding?
What is ds designer?
How a routine is called in datastage job?
How one source columns or rows to be loaded in to two different tables?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
How to find value from a column in a dataset?
