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
- 2601 Views
- IBM, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
ORA-23433: executing against wrong master site string
ORA-01877: string is too long for internal buffer
RMAN-06137: must have recovery catalog for REPORT SCHEMA AT TIME
ORA-01503: CREATE CONTROLFILE failed
TNS-00082: NOTE: the user MUST specify a trace level
ORA-01485: compile bind length different from execute bind length
ORA-03210: DBMS_ADMIN_PACKAGE invalid option specification
DRG-11220: Third-party filter is out of memory.
SQL*Loader-00458: Comparison text ('string') of CONTINUEIF LAST must be non-whitespace
ORA-14253: table is not partitioned by Composite Range method
KUP-04074: no write access to directory object string
ORA-10620: Operation not allowed on this segment
Oracle Errors 
