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
- 5334 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
How global cursor can be declare with dynamic trigger ?
what is column? : Sql dba
Is sqlexception checked or unchecked?
What is sql query limit?
What is the use of non clustered index?
How do you pronounce sql?
Is sql a programming?
What are pl/sql cursors?
How can we avoid duplicating records in a query?
how to use case expression? : Sql dba
How to execute a stored procedure?
How do I count duplicates in sql?
How does join work in sql?
how many columns can be used for creating index? : Sql dba
How do you use a while loop in pl sql?
