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 86913. 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 31354. 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 2716Post New Fintellix SQL PLSQL Interview Questions
What is javascript bom?
With what extension you can save the list of tests in a file to run in test batch runner?
What do you understand by birds-eye-view?
Describe a marketing plan you developed. What was the result of implementing that plan?
hi guys what happens if you are absent for a supplymentry exam?
What is vector pFPV25.1 ?
What is namespace & why it is used in c++?
What type of noise is best for sleep?
Name the different categories of Hotel Management. Which one is generally large placement cell?
What are the major sectors involved in aircraft maintenance?
List the benefits of using an expression language?
How to decrease opening & closing time of on/off valve?
Explain how DSECT parameter is used in BMS ?
What are alternatives to RSA?
 What are the oracle DML commands possible through an update strategy?