Answer / kumari

SELECT TOP (3)with ties empsalry
FROM empsalr

order by empsalry desc;

Answer / neo devan

select max(sal) from emp having max(sal)!=(select max(sal)
from emp where max(sal)!=(select max(sal) from emp));

Which is better Oracle or MS SQL? Why?

2 Answers   Bally Technologies,

---

Explain implicit cursor.

0 Answers  

---

Can a field be used in a report without it appearing in any data group ?

4 Answers   Oracle,

---

What are the oracle differences between nvl and coalesce

0 Answers  

---

how to get second highest sal of emp table

6 Answers  

---

According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?

2 Answers  

---

Anybody can tell me, how do we find second largest emp salary from emp table.. Thanks in advance ...

10 Answers   Cognizant, ID, NTTF Nettur Technical Training Foundation, Sony, Verizon,

---

 What are the oracle DML commands possible through an update strategy?

0 Answers   Informatica,

---

what are the things that you consider while creating indexes on partitioning tables?

1 Answers  

---

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

0 Answers  

---

How to use windows user to connect to the server?

0 Answers  

---

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,

---