2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B
2 73763. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);
1 24184. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;
1 1958Post New Fintellix Interview Questions
Define say() function in perl?
What is statement level trigger?
Explain exception chaining in java?
What is namespace in oop?
What are the features of UML?
Can gmail be used in outlook?
What is Indexing? how did u implement indexing?
What is 'union excise duty'?
Why in SAP external number range should be selected for depreciation posting . any specific reasons for that explain me? Raj
Where do we store db configuration and how can we change that?
How do you click f4 in excel?
Explain case statement in Ruby?
Explain how you can migrate to Xcode?
Compare r and python?
Is indentation required in python?