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...
2541Hi 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...
2694Post New IBM Oracle Errors Interview Questions
How are the elements of a gridbaglayout organized in java programming?
Explain function?
What exactly is a pivot table?
Examples of situations when your initiative ideas.
Define notching?
What is blockchain?
What is difference between onload and ready?
what is the purpose of indicators in rpg?
What is the difference between the 'all perils' and 'specified perils' coverage in home insurance coverage? : insurance sales
I m wrkin as an assitant manager (age 24 yrs)in ESSAR i wana to rollbak to my native place Delhi..nd njoy abit cool life..wat r the opportunities at call centre at higher levels....
Why c# is called type safe language?
What widgets can not do ?
Which banking services can be used through information technology (it)?
What is the difference between dynamic and non-dynamic changes in the console?
What descriptive information does the NEC require to be marked on all conductors?