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...


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Oracle Errors Interview Questions

DGM-16900: Unable to initialize client

1 Answers  


ORA-24404: connection pool does not exist

1 Answers  


ORA-01682: read-only DB cannot allocate temporary space in tablespace string

1 Answers  


ORA-25272: Signature does not exist for the given reciever and message id.

1 Answers  


ORA-16638: could not get the instance status

1 Answers  






ORA-16603: Data Guard broker detected a mismatch in configuration ID.

1 Answers  


ORA-22282: non-contiguous append to a buffering enabled LOB not allowed

1 Answers  


ORA-16093: dependent archive log destination is not LGWR-enabled

1 Answers  


ORA-27487: invalid object privilege for a string

1 Answers  


DRG-11622: URL store: unknown HTTP error getting string

1 Answers  


ORA-39958: invalid warning category qualifier

1 Answers  


ORA-19649: offline-range record recid string stamp string not found in file string

1 Answers  


Categories