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
ORA-16516: The current state is invalid for the attempted operation.
ORA-15076: Emulating I/O errors on the OSM disk
ORA-26076: cannot set or reset value after direct path structure is allocated
DRG-11120: failed to write to file string
ORA-01939: only the ADMIN OPTION can be specified
NID-00103: Missing password in connect string "string"
O2F-00310: Illegal or missing identifier name
ORA-09752: pw_attachPorts: port_allocate failed.
TNS-12592: TNS:bad packet
O2F-00335: Internal error in O2F component of OTT
ORA-06317: IPA: Local maximum number of users exceeded
PLS-00704: 'string' must be declared as an exception