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...
2139Hi 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...
2255Post New IBM Oracle Errors Interview Questions
Define miasma notion of disease?
is the syllabus of group1 and group2 same for all graduates like btech,bsc,bcom?
Iwant to calculate the production of 1 labour for concrete casting which includes shuttering,scaffolding,steel fixing,concreting, deshuttering and curing in 8hours.But i am not able to determine it approximately would you pls.??
How to deploy Silverlight Webparts?
Define what is the importance of valence shell and valence electrons?
How can we implement validation in mvc?
What do you mean by Function Overloading in java?
What are string functions in excel?
What is abstraction c++?
What is the modification assistant?
What are the main differences of qtp and win runner?
How to send an email using siebel application? Other than using f9 functional key?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
How important is c++?
what is the transport method in SOAP?