You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.

3 Answers   Amazon, HCL,

---

What is user managed backup in Oracle?

0 Answers   MCN Solutions,

---

What is logical backup in oracle?

0 Answers  

---

What is the purpose of tables, private synonyms and public synonyms in Oracle?

0 Answers   HCL,

---

Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.

4 Answers   JPMorgan Chase,

---

How to rename a column in an existing table?

0 Answers  

---

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

0 Answers  

---

How to rename an index?

0 Answers  

---

How to write a query with a full outer join in oracle?

1 Answers  

---

Is oracle an operator?

0 Answers  

---

What is background process in Oracle?

0 Answers   MCN Solutions,

---

create or replace procedure show_tab_rec ( P_tab VARCHAR2 ) IS cmd varchar2(50); begin cmd := 'select * from '|| P_tab; for int in ( execute immediate cmd ) loop dbms_output.put_line ( int.ename||' '||int.deptno); end loop; end; when i m compling this procedure i m getting this error PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one of the following: . ( ) , * @ % & | = - + < / > at in is mod remainder not range rem => .. <an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_ between || multiset member SUBMULTISET_ PLZ solve this error give this question answer asap Thanks advance.......

1 Answers   HCL,

---