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-30555: global index partitioning key is an expression
ORA-29741: IMR active for some, but not all members of cluster
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
LPX-00216: invalid character ~1u (~2X)
PCC-02400: This host variable must be declared as a pointer type
ORA-07507: scgcm: unexpected lock status condition
RMAN-06250: Report of files that need backup due to unrecoverable operations
CLSR-00525: prsr initialization failed
IMP-00050: Dump file and log file cannot be identical
ORA-02704: osndopop: fork failed
DRG-10706: length of string exceeds maximum size of string
ORA-16706: no resource guard is available