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?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / krish
1)select deptno,count(*)
from emp having count(*)=0 group by deptno;
2)select deptno,count(*)
from emp having count(*)>10 group by deptno;
3)select empname from emp where deptno is null;
4)select emp.deptno,emp.ename,dept.deptno,dept.dname
from emp,dept
where emp.deptno=dept.deptno(+);
Is This Answer Correct ? | 2 Yes | 6 No |
write a qurey for finding the length of the sting.
What is a self join ?
what are aggregate and scalar functions? : Sql dba
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
what are the different functions in sorting an array? : Sql dba
Does sql backup shrink transaction log?
Why truncate is used in sql?
define sql insert statement ? : Sql dba
Does pl sql work in mysql?
Enlist the data types that can be used in pl/sql?
How do I save the results of sql query in a file?
Is json a nosql?