Interested to Buy Any Domain ? << Click Here >> for more details...
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...
- 0 Answers
- 2691 Views
- IBM, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
SQL*Loader-00947: subpartition load requested and string has enabled triggers or constraints
ORA-02799: Unable to arm signal handler
ORA-14099: all rows in table do not qualify for specified partition
ORA-02072: distributed database network protocol mismatch
ORA-27413: repeat interval is too long
QSM-01053: NORELY referential integrity constraint on table, string, in TRUSTED/STALE TOLERATED integrity mode
ORA-25531: MTTR specified is too small: string
ORA-36968: (XSRELTBL11) workspace object must be a relation.
IMG-00586: output format does not support the specified pixelOrder
ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option
ORA-10566: Test recovery has used all the memory it can use
PCC-00145: This statement can only be used with THREADS=YES
Oracle Errors 
