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;

What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.

5 Answers   Polaris,

---

what is the use of double ampersand (&&) in sql queries?

0 Answers  

---

Explain about various levels of constraint.

0 Answers  

---

How to download oracle sql developer?

0 Answers  

---

Is a secondary key the same as a foreign key?

0 Answers  

---

---

What are the steps for performance tuning.

0 Answers  

---

Why we use pl sql?

0 Answers  

---

how to include comments in sql statements? : Sql dba

0 Answers  

---

What is the difference between left join and right join?

0 Answers  

---

How long does it take to learn pl sql?

0 Answers  

---

Can 2 queries be executed simultaneously in a distributed database system?

0 Answers  

---

how to select first 5 records from a table? : Sql dba

0 Answers  

---