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-04060: insufficient privileges to execute string
ORA-30201: Unable to load NLS data object
ORA-27155: could not execute file
PLS-00210: an OTHERS clause is required in this CASE statement
ORA-30462: unsupported operator: string
ORA-01620: no public threads are available for mounting
ORA-06138: NETTCP: error during connection handshake
ORA-16145: archival for thread# string sequence# string in progress
NID-00506: SETNAME Set a new database name only NO
ORA-39954: DEFERRED is required for this system parameter
ORA-25102: PARALLEL option can only be used with ALTER INDEX REBUILD
ORA-07224: sfnfy: failed to obtain file size limit; errno = string.