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...
2536Hi 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...
2691Post New IBM Oracle Errors Interview Questions
How do you name a formula?
What is defect prevention?
What is tool menu in ms word?
how to stop beam concrete between column
Explain the callback functions in cakephp?
Is it safe to use ubuntu?
How we improve our pricing procedure?
What made you decide to be a dental assistant?
Hi this is rajeev hre i m gng to complete SAP CRM TRAININNG BASE CUSTOMIZATION + SALES. m i eligible to get a job or i will have to do other modules like marketing & CIC. PLZ tell in which can i get gd break. m having 2 yrs of EXPNCE as NAVISION CONSULTANT & rt now m not getting calls on this so i shifted to SAP CRM .WAT R POSIIBLITIES . PLZ SUJJEST & SEND INTERVIEW QUESTIONS AT :rajeevroy84@gmail.com rajeev_roy84@rediffmail.com,931564306 . m in delhi
List some features of php that are deprecated in php
What is b2c and b2b business model?
Explain how you can deploy a web application using war files?
what is called the inverd level of mabhole chamber?
Explain enable novalidate constraint.
How can you see a silverlight application in full-screen mode?