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
- 2744 Views
- IBM, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
NID-00404: DBNEWID - Completed succesfully.
ORA-06514: PL/SQL: The remote call cannot be handled by the server
ORA-12058: materialized view cannot use prebuilt table
QSM-01068: no dimensions present
ORA-30366: child JOIN KEY columns not in same relation as child level
PLS-00925: native compilation failed: Unable to create C file (string string)
KUP-03018: invalid date mask "string" specified for column string
ORA-09832: infoCallback: bad message format.
NNO-00053: duplicate domain description for domain "string"
ORA-19571: %s recid string stamp string not found in controlfile
ORA-00097: use of Oracle SQL feature not in SQL92 string Level
TNS-00288: Navigator: Failed to Disable Interchange
Oracle Errors 
