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
- 2661 Views
- IBM, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
LPX-00657: Invalid output PI '~S'.
ORA-39143: dump file "string" may be an original export dump file
Why we can't perform DML operations on Materialized views???
SQL*Loader-00460: Column (string), form of use (number) does not match char set id of (number)
ORA-38405: quotes not allowed in the attribute set name
ORA-25404: lost instance
ORA-12671: Shared server: adapter failed to save context
RMAN-08503: piece handle=string comment=string
ORA-24145: evaluation context string.string already exists
ORA-26680: object type not supported
NNL-00271: Default domain is now "string"
TNS-04085: Password not changed since last save.
Oracle Errors 
