Interested to Buy Any Domain ? << Click Here >> for more details...
Q1.all the depts which has more then 10 empls? Q2.all the
dept which does not have any emply? Q3 all the emp which
does not have any dept? Q4 get all the emply detais with
the dept details it dept is exit otherwise any emp details?
Q5 how to debugg the dynamic sql and packages?
- 2 Answers
- 5217 Views
- I also Faced
- E-Mail Answers
Answer Posted / ramkiran
select emp.deptno,emp.ename,dept.deptno,dept.dname from
emp,dept
where emp.deptno(+) = dept.deptno
order by 1
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the use of prepared statement?
What is sql clause?
What is the difference between instead of trigger and after trigger?
How many types of literals are available in pl sql?
Why is stored procedure faster than query?
What is the difference between sql, mysql and sql server?
Difference between global and parameter variables?
What are the types of records?
Is full outer join same as cross join?
Can a view be mutating? If yes, then how?
How to handle bulk data?
What is the benefit of foreign key?
Is left join and outer join same?
How to get help at the sql prompt?
what is the difference between a having clause and a where clause? : Sql dba
