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...

2737

RMAN-05017: no copy of datafile number found to recover

2410

mount: mount to NFS server failed: System Error: Connection timed out

3663

today's peformance is less than yesturday.it took 1 mint and today's performance is 7 mints.guys can anyone answer to mu question in sql

2443

write a database figure to implement the master detained relationship.

2931

How to view the error log for any specific instance?

2476

When you get following error? Error 3154: The backup set holds a backup of a database other than the existing database.

2518

What is the use of NOLOCK locking hint?

1780

IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

3150

what is the instrument that used in Mechanical Energy??

2676

What is the meaning of lock escalation and why/how to stop this?

2647

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...

2591

ORA-16627: No standby databases support the overall protection mode.

3982

What is Mutex error in Triggers?

3059

What severity level errors are managed in TRY-CATCH block?

2218