PL/SQL theoretical questions

[kiss07]

Hi,

i want 2 and 3 rd max salary in a table .i want a single query.

please help..

Arun

[mailtothiyagarajan]

Hi,

i want 2 and 3 rd max salary in a table .i want a single query.

please help..

Arun

I have used the inline view concept for this


Query for nth max salary :

select s.salary from
(
(
select dense_rank() over (order by max(salary) desc) n,salary
from
employee
) s
)
where s.n=&n;

[bonzi1405]

Below will return n,n+1 higest salary of a table.


select min(salary) sal
from
( select salary from employee order by salary desc)
where rownum<=&n
union
select min(salary) sal
from
( select salary from employee order by salary desc)
where rownum<=&n+1

[debasisdas]

Dear
mailtothiyagara jan

have u tested the code before posting

[Mani kansal]

select sal from (select sal from emp order by sal desc) where rownum in(2,3)

[kiss07]

Dear friends,

I known about pre defined exception:
i want a sample programs in each of predefined exception.

example:

invalid cursor :

one sample program. when exception is raised in ivvalid cursor
same as others exceptions...


pls anybody help....

arun..

[kiss07]

Dear debas,

Can u explain about sql tuning:

what are the steps are doing sql tuning . I want to know about basic ideas

in sql tuning and performance tuning. what are the types?..

Pls...

Arunkumar...

[debasisdas]

PLease follow this Link

Hope it might be useful for u.

[debasisdas]

Invalid cursor exception is raised when u try to do somthing which is not allowed .
for ex

accesing the cursor variable after the cursor is closed.

[debasisdas]

ZERO_DIVIDE exception
=============== ========

DECLARE
I INT:=&I;
J INT:=&J;
K INT;
BEGIN
K:=I/J;
DBMS_OUTPUT.PUT_LINE(K);
EXCEPTION
WHEN ZERO_DIVIDE THEN
RAISE_APPLICATION_ERROR(-20002,'CANT DIVIDE BY ZERO.....!');
WHEN OTHERS THEN
RAISE_APPLICATION_ERROR(-20003,'SOME OTHER ERROR........!');
END;