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
- 2612 Views
- IBM, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
ORA-14522: Partition-level default tablespace string block size [string] for string string does not match existing string block size [string]
DRG-12001: Please enter username:
ORA-12657: No algorithms installed
ORA-30376: prevent sharing of a parsed query of an explain rewrite session
ORA-37074: (XSMCSESS02) Variable workspace object has no default aggmap.
ORA-12065: unknown refresh group identifier string
ORA-12407: unauthorized operation for policy string
ORA-06560: pos, string, is negative or larger than the buffer size, string
ORA-01308: initialization parameter utl_file_dir is not set
ORA-02438: Column check constraint cannot reference other columns
NNO-00068: warning: administrative region check failed, next check in number seconds
RMAN-06163: some datafiles cannot be recovered, aborting the RECOVER command
Oracle Errors 
