tab1 tab2
1,a 1,d
2,b 3,c
perfoms outerjoin what is the o/p?
write sql query for outerjoin?
- 3 Answers
- 7828 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
what is the use of materialized view?
Describe the main features of datastage?
Highlight the main features of datastage?
What are the types of containers?
How can one find bugs in job sequence?
options available in sequence job to run,validate?
What are the different plug-ins stages used in your projects?
Have you used Unstructured data?
How a routine is called in datastage job?
how to delete one row in target dataset
How rejected rows are managed in datastage?
Is possible to create skid in dim,fact tables?
What are the important features of datastage?
How to read the length of word in unix?
What are the functionalities of link partitioner?
