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

2613

---

what is the max. and mim. height of vertical post in informatry sign board which is used in highway projects.

2766

---

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

2751

---

How to know th details about an electrical Drawing ? Please mention the easy method.

2462

---

what is the difference between delta delta and star delta connection transformer? why we use delta delta transformer since it need earthing transformer for grounding?

2103

---

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7375

---

What is the selection process of breakers. Can any one please give a formulation on same?

2172

---

Hi friends ineed finacial analyst interview question Pls share it

2050

---

which protocol it user to connect manage server to admin ? where it is defined ?

8140

---

how many languages are listed in the 8th schedule of the indian constitution?

2009

---

The distance between the magnetic north pole and magnetic south pole of a bar magnet is called the...?

1783

---

th how could we differentiate between armoured copper and armoured aluminium cable what is the basic application? why we prefer the armoured copper as compared to armoured aluminium.

1982

---

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2882

---

whaat is blister in box girder bridge and what is its function..

4943

---

Why USP put two methods for tapped density? When I should use each one?

3151

---