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 do you perform SAP ERP integration with SAP SRM to perform upload of Contracts?
Explain the process of spilling in MapReduce?
how does sas handle missing values in assignment statements? : Sas programming
What is f12 in startup?
How to debug idoc manually? If I want to extend the standard idoc say matmas, where we have to write code for extension?
i am electronics & comm engg & appling 4 the AAI jr executive (electronics/ATC) written test. pls forward me the syllabus & old question papers.I will be very much thankful to you akil403@yahoo.com
what is the complex transformation you used in informatica
What are types of hive built-in functions?
Why apache tomcat is used?
How is jsp used in the mvc model?
What is seo and list its types?
How are transactions and blocks encrypted in the bitcoin implementation?
How do I link spreadsheets in excel?
What are the different types of advices?
What does plv msg allows you to do?