Hi guys, I have four tables those are emp,dept,eliminate and uneliminate. i wrote small cursor..when i run, it display one error (ORA-01403 nodata found)... The query is: Declare cursor c1 is select e.ename emp_name from emp e,dept d where e.deptno=d.deptno group by deptno; r1 c1%rowtype; test_emp varchar2(200); begin for r1 in c1 loop begin select eliminate_emp into test_emp from eliminate t,uneliminate ut where t.number=ut.number and t.deptno=e.deptno and rownum<1; end; dbms_output.put_line(r1.emp_name); end loop; end; Thanks...
2661Hi guys, I have four tables those are emp,dept,eliminate and uneliminate. i wrote small cursor..when i run, it display one error (ORA-01403 nodata found)... The query is: Declare cursor c1 is select e.ename emp_name from emp e,dept d where e.deptno=d.deptno group by deptno; r1 c1%rowtype; test_emp varchar2(200); begin for r1 in c1 loop begin select eliminate_emp into test_emp from eliminate t,uneliminate ut where t.number=ut.number and t.deptno=e.deptno and rownum<1; end; dbms_output.put_line(r1.emp_name); end loop; end; Thanks...
2798Post New IBM Oracle Errors Interview Questions
What is delegate? Can delegates be retained?
What is an OS? Explain it to a layman.
What are the pricing models for ec2 instances?
How we can scale Reshift database?
How to associate functions with objects using javascript?
How to sign out from forms authentication?
Explain Any Standalnoe Application with rispect to OSI model, letus Consider Voice Recognition....!! One Has To tell function of all layers with rispect to given Application.
How do you add default rules in transformer?
Iam a fresher. I completed B.TECH in June 2008. what have u been doing after june 2008?
What are the important aspects to be considered in the planning phase of automation?
What is a heat map?
How do you create the burn down chart?
How do I change the default settings in excel?
Explain what are the characteristics that distinguish direct marketing? : insurance cold calling
What is group?