find out the third highest salary?

92 Answers   CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon,

---

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,

---

what are archived logs?

0 Answers  

---

Can select statements be used on views in oracle?

0 Answers  

---

What do you mean by a database transaction & what all tcl statements are available in oracle?

0 Answers  

---

What is the difference between Delete, Truncate and Drop in Oracle?

0 Answers   MCN Solutions,

---

Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.

1 Answers   IBM,

---

why pl sql doesn't support retrieving multiple records

1 Answers   Mphasis,

---

Point the difference between translate and replace?

0 Answers  

---

How many categories of data types?

0 Answers  

---

how to store only time in a data base table

2 Answers  

---

What privilege is needed for a user to create views in oracle?

0 Answers  

---