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-23442: object already exists for the refresh group template
ORA-01106: database must be closed before dismounting
ORA-30575: ConText Option not installed
RMAN-03012: fatal error during compilation of command
ORA-12992: cannot drop parent key column
SQL*Loader-00943: incorrect datafile string specified for table string partition string
ORA-08003: sequence string.NEXTVAL exceeds internal limits
ORA-00827: could not shrink sga_target to specified value
DRG-12508: null stop words are not allowed
ORA-39960: scope can only be SYSTEM or SESSION
ORA-03216: Tablespace/Segment Verification cannot proceed
ORA-02844: Invalid value for the leave open flag