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 a join? : Sql dba

0 Answers  

---

how to get help information from the server? : Sql dba

0 Answers  

---

1.when will you use week refcursor and when will you use strong ref cursor ? 2.what is the use of sql trace..how do you use it ? 3.can you please send all the sql plus commands...like set line 6000....

1 Answers   Satyam,

---

What is differance unique key and primary key.

7 Answers   EDS,

---

What are different types of sql commands?

0 Answers  

---

---

What is scalar data type in pl sql?

0 Answers  

---

How do you explain an index number?

0 Answers  

---

What is prepared statement in sql?

0 Answers  

---

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

0 Answers  

---

What is primary key sql?

0 Answers  

---

How to use distinct and count in sql query? Explain

0 Answers  

---

How to add Foreign key in a table after the creation of the table?

5 Answers   Satyam,

---