write a procedure to find top second no from a list of
numbers
Answer Posted / roshan
create or replace procedure pr_getmax(enter_number in
number,sal out number)
as
begin
select salary into sal from
(select rownum rn,salary
from
(select
a.salary
from
employees a
order by a.salary desc) )a
where
a.rn = enter_number;
end;
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is percent sign in sql?
How do I create a sql script?
What is data control language?
How do I run pl sql in sql developer?
What are the key differences between SQL and PL SQL?
Can a procedure in a package be overloaded?
What is the command used to fetch first 5 characters of the string?
Can a trigger call a stored procedure?
How to install oracle sql developer?
What does partition by mean in sql?
What are the packages in pl sql?
How do I view a sql database?
What is on delete restrict?
What is sql server and ase?
Is it possible to update views?