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
- 2269 Views
- IBM, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
TNS-00046: INTCTL: Could not contact the CMANAGER on address
ORA-39086: cannot retrieve job information
TNS-00241: Connection Manager: Logging is now OFF
NNL-01040: Data streams opened by server: number
ORA-13769: Snapshots string and string do not exist.
RMAN-06425: <datafile pathname not available>
NMP-00008: SNMP message has incorrect version, version 0 is required
ORA-16600: Failover operation can only be submitted at target database.
ORA-16713: The resource guard timed out while servicing the request.
ORA-00296: maximum number of files (string) exceeded for RECOVER DATAFILE LIST
ORA-25252: listen failed, the address string is a non-persistent queue
RMAN-20218: datafile not found in recovery catalog
Oracle Errors 
