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
- 2743 Views
- IBM, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
ORA-02261: such unique or primary key already exists in the table
ORA-29875: failed in the execution of the ODCIINDEXINSERT routine
ORA-31496: must use DBMS_CDC_PUBLISH.DROP_CHANGE_TABLE to drop change tables
ORA-23407: object name string must be shaped like "schema"."object" or "object"
PCC-00122: Input file name and output file name are identical
SQL*Loader-00552: insufficient privilege to open file
ORA-36956: (XSFCAST25) There are only number PERIODICITY values. You cannot specify more OFFSET values.
ORA-01470: In-list iteration does not support mixed operators
NNL-00408: Answers:
ORA-01699: tablespace 'string' is being imported for point in time recovery
PLS-01472: In a set_function_specification, if DISTINCT is present, the expression must be a column_specification
NNL-00262: Request forwarding is currently disabled
Oracle Errors 
