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
- 2355 Views
- IBM, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
RMAN-06467: could not translate DBA: number
NID-00403: DBNEWID - Completed with validation errors.
ORA-29253: Invalid count argument passed to procedure dbms_sql.define_array
ORA-01620: no public threads are available for mounting
ORA-10663: Object has rowid based materialized views
NNL-00905: NOT AUTHORITY responses sent: number
NID-00105: Need to specify "LOGFILE=<logfile>" when using APPEND=YES option
PCC-01013: Invalid use of PIC N array variable "string" at line number in file string
ORA-28539: gateway does not support result sets
TNS-01167: The command string is not supported by the listener contacted
ORA-39726: unsupported add/drop column operation on compressed tables
ORA-29282: invalid file ID
Oracle Errors 
