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...
1 2695Hi 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...
1 2830Post New IBM Oracle Errors Interview Questions
What is the current stable version of php? What advance thing in php7?
Hai Frds i want to join in testing tools course , plee tel me which was the Best institute, plsss reply me, i am waiting for ur reply....
How much is excel for ipad?
how to create user name stape by stape in cisco router {with command}
hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.
What is sql server query analyzer?
what salary you expect???
How to convert GSS duct volume in KG for all guages
hello sir, could u plz send me a sample placement paper for hpcl trainee engg exam..(electronics stream)...hoping to hear from u at the earliest. Thanking you.
hello all, I need some sample placement papers in lion bridge.. can anyone help me?
What are your salary requirements at McDonalds?
1.what is the name of program to create invoice automatic from po.? 2.How to auto upload the bank statement? 3.PO tax has not flown to invoice . why? Debit memo not generated for return of goods.??
Explain demographic parity and its importance in AI fairness.
Anybody please send me the papers of the reliance exam (apti and tech) so that i can go through it) mail me at raminder_verma@rediffmail.com
Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid: