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
- 8964 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
why do u need the IOS upgradation in a FC switch
What are the stages in datastage?
how to abort the job its matain duplicates?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Name the different sorting methods in datastage.
Differentiate between datastage and informatica?
What are transforms and what is the differenece between routines and transforms?
How do you import and export data into datastage?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
What steps should be taken to improve Datastage jobs?
What are the various kinds of containers available in datastage?
In Datastage, how you can fix the truncated data error?
How do you generate sequence number in datastage?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
Have you have ever worked in unix environment and why it is useful in datastage?
