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
- 4625 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 primary key?
Can we commit inside a trigger?
What is a boolean in sql?
Which nosql database is best?
How do you truncate?
How many types of keys are there in sql?
What are the different types of triggers?
what is meant by urlencode and urldocode? : Sql dba
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
What is the use of partition by in sql?
Is sql better than excel?
What is the difference between count 1 and count (*) in a sql query?
Can %notfound return null after a fetch?
Does google use sql?
