Interested to Buy Any Domain ? << Click Here >> for more details...
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 85703. 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 30764. 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 2629Post New Fintellix SQL PLSQL Interview Questions
- Fintellix Oracle AllOther Interview Questions (1) Fintellix SQL PLSQL Interview Questions (6)
What is a sting?
Can captcha be automated?
How many tags are defined in xhtml 1.0?
What the advantages of using Unions?
I have got a call of IOCL interview for projects having 2yrs experience. What sort of questions should I expect in the interview?
What is platform-driven design?
How do I replace a system32 file?
what is loan operations and what are the complete process form from making customer to closure of loan
When latest angularjs was released?
how can i create a table from front end to back end in wabe page?
What portal resources can’t be separated for the virtual portal?
What are the differences between “insert”, “update” and “modify”.
What is EXPORT AND IMPORT in Quality Center (pl. Explain with easy steps to understand.)
I WANT BHEL PREVIOUS QUESTION
What is classification in machine learning?
