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...
2123Hi 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...
2243Post New IBM Oracle Errors Interview Questions
Why stringbuilder is not thread safe?
How you will do Mass Insert through trigger?
Mention two types of dislocations.
although ckt breakers have taken the place of old fuse. But instead of it , these older ones are still used in the industries and homes ? why .... what are their advantages and disadvantages ? which one is leading and winning the race and competition ?
How to display n-th line of a file in Unix?
What is SKM and when we will use this SKM?
What is atomic and nonatomic in iOS operating system? What is run loop in iOS ?
how does a generator work?
How to bring advanced search page before normal search page?
Name the different modules of the spring framework?
What is a sigmoid function in Machine learning?
How do I remove duplicates in two columns?
Is postgresql a language?
What are the types of linked list?
What is an SEO package?