Answer / 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;

How is a PL/SQL code compiled?

0 Answers  

---

How do I make my sql query run faster?

0 Answers  

---

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

0 Answers  

---

How do u count no of rows in a table?

8 Answers   CTS,

---

How do I count rows in sql query?

0 Answers  

---

List out the acid properties and explain?

0 Answers  

---

What is the usage of the distinct keyword?

0 Answers  

---

What is the difference between the implicit and explicit cursors?

0 Answers  

---

What are the advantages of the packages

6 Answers   Oracle,

---

Why do we create stored procedures & functions in pl/sql and how are they different?

0 Answers  

---

How do I kill a query in postgresql?

0 Answers  

---

----> There is a table T with two columns C1 and C2. The data is as below: C1 C2 1 4 2 5 3 6

4 Answers   ICICI,

---