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...
2659Hi 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...
2798Post New IBM Oracle Errors Interview Questions
what are Operators and explain with an example?
If one wanted to display the value of a variable named answer in the log file, what would the first argument to the previous command look like?
What are tabs in excel?
What are the different type of N: N relationships we have in CRM?
How to get the query of a table in sql server?
What are the things to do when approaching the port?
GD about the reality show on TV
Have you worked with Advanced Adapter Engine Extended (AEX) and Java-only scenarios in SAP Process Orchestration? If so, what was your experience?
Can you explain the concept of autonomous decision-making and its implications for AI?
Explain with examples any 2 features of OOPS.
How to create and run testng.xml?
what is the Differed Tax Liability & How it is calculate ?
What are the types of folder present in cognos?
Why swift is the best language?
How to root mirror in linux?