What is prepared statement in sql?
No Answer is Posted For this Question
Be the First to Post Answer
What is latest version of sql?
Which function is used to return remainder in a division operator in sql?
Types of cursor locks and explanation each of them ?
What is sql performance tuning?
what is foreign key? : Sql dba
a procedure one in two out parameters i am waiting it in a sql query can i get the output
State the advatage and disadvantage of Cursor's?
Can you have a foreign key without a primary key?
What is error ora-01000: maximum open cursors exceeded
Which is faster count (*) or count 1?
what are the advantages of primary key over unique+notnull
7 Answers Consultancy, LGS, Oracle,
4. 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;