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
- 2730 Views
- IBM, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
ORA-27465: invalid value string for attribute string
ORA-39951: incomplete values specified for PL/SQL warning settings
ORA-26062: Can not continue from previous errors.
SQL*Loader-00476: count of elements for collection is not set or null, 0 will be used
NNL-00906: NOT A LEAF NAME responses sent: number
ORA-00820: Specified value of sga_max_size is too small, needs to be at least stringM
PCB-00702: Out-of-range item number
ORA-29522: authorization error for referenced name string.string
ORA-09921: Unable to get information label from connection
ORA-19908: datafile string has invalid checkpoint
NNO-00152: warning: hint count number exceeds maximum of number, first number will be loaded
ORA-28001: the password has expired
Oracle Errors 
