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...
2120Hi 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...
2237Post New IBM Oracle Errors Interview Questions
what is the form name for use functional spec? what are the steps in functional specs?
What is the default font used in ms word 2013 document?
What are pleura?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
How do you find the index of an element in an arraylist?
Q2. Explain the difference between a MONOLITHIC KERNAL and a MICROKERNAL?
Can age be a variable?
What is is a match code? : abap data dictionary
How spark is used in hadoop?
What is performance optimization?
Where the sql logs gets stored?
if you get a better package than here what will you do accept that offer or reject that
How do you stop weblogic using the command line?
Does the extrusion process for a355 and a356 alloy have any impact on the impact energy?
What are the important characteristics of soap envelope element?