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 86983. 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 31414. 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 2720Post New Fintellix SQL PLSQL Interview Questions
- Fintellix Oracle AllOther Interview Questions (1) Fintellix SQL PLSQL Interview Questions (6)
How to generate & update application key in laravel 5?
Give the description of sp2/o cell line and its significance.
What is the best web server to use?
how many current required for hypo test
what is inspection and supervision reports and their uses
What is difference between XElement and XDocument?
Why local variables are stored in stack?
What is the fork() system call?
Where is the wordpress content stored?
What are new in bo 5.1?
Write a program which returns the first non repetitive character in the string?
What is monosysplex?
What version of windows do I have?
What are the elements of dbms?
what isload waring calculation
