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
- 2450 Views
- IBM, I also Faced
- E-Mail Answers
ORA-02230: invalid ALTER CLUSTER option
SQL*Loader-00486: sql-strings may not be specified for collection field string
TNS-04010: Command cannot be issued before the ADMINISTER command.
AMD-00117: input file "string" not found
ORA-19695: fixed table x$krbmsft has not been populated
SQL-02130: EXEC TOOLS interface is not available.
TNS-00117: Internal error- No data passed through pump
RMAN-04010: target database Password:
PCC-02111: CHAR_MAP option ignored. Only CHAR_MAP=VARCHAR2 allowed for DBMS=V6
RMAN-06064: creating datafile fno=string name=string
TNS-00024: INTCTL: Unable to contact Navigator to obtain Connection Manager address
ORA-38765: Flashed back database cannot be opened read-only.
Oracle Errors 
