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 sql a scripting language?

690

---

How can we find duplicate records in a table?

662

---

What are inbuilt functions in sql?

794

---

What do you understand by pl/sql records?

721

---

What is package in pl sql with an examples?

731

---

---

What are the sql aggregate functions?

811

---

explain what is mysql? : Sql dba

787

---

What is a .db file?

724

---

what is recursive stored procedure? : Sql dba

714

---

What is a behavioral trigger?

695

---

What is a column in a table?

770

---

What is constant in pl sql?

708

---

what is the bond code in materialized view?

2683

---

How do I view a sql trace file?

756

---

What is the maximum number of rows in sql table?

741

---