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
- 5431 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 character functions?
How you improve the performance of sql*loader? : aql loader
What is on delete set null?
Is inner join faster than left join?
How can we implement rollback or commit statement in a trigger?
Is primary key always clustered index?
What is the difference between the sql*loader and import utilities? : aql loader
Which is faster union or join?
What are conditional predicates?
what is a cursor? : Sql dba
What is the difference between an inner join and an outer join?
Why is sharding used?
how would you get the current date in mysql? : Sql dba
How is indexing done in search engines?
Can dml statements be used in pl/sql?
