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...
2601Hi 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...
2743Post New IBM Oracle Errors Interview Questions
How can we use lightning components with the salesforce1 mobile app ? : salesforce lightning component
why you want to lecturer
Is there a 64 bit version of office 365?
What are the types of power in electrical power?
How do I apply a label to an older version of a file?
agar hum koi sale return 3 month ke andar hi receive krte hai or part uski cst purchase ka bill deti hai or humse c form mangti hai to kya hum use LS-10 me tax benefit ke liye and LP-3 me c form issue krne ke liye kyoki central purchase ka haryana vat me benefit nhi milta kya dono form LP-3 and LS-10 me hum us return ko show kar skte hai
What is a decorator in angular?
Differentiate between new and malloc(), delete and free() ?
What impacts will the Internet of Things (IoT) have?
What is RunBase?
Which JavaScript objects are not accessible to web worker?
Where the applications and where ware house management system is used?
Define peak time.
Explain the key features of Spark.
why actual valve timing diagram is different than ideal valve timing digram of a 4 stroke engine?