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;

Can we delete column in sql?

0 Answers  

---

How does postgresql compare to "nosql"?

0 Answers  

---

What is the least restrictive isolation level? : Transact sql

0 Answers  

---

Why do we create views in sql?

0 Answers  

---

Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause

6 Answers   HCL,

---

how do you count the duplicate records in a table

10 Answers   Tech Mahindra,

---

can we write stored function in out parameters? how to call through select statement? how to written more than one value plz give the exmple?

1 Answers  

---

What is an oracle stored procedure?

0 Answers  

---

What are different types of refreshment techniques of materialised view

2 Answers  

---

what is foreign key? : Sql dba

0 Answers  

---

Can we call dml statement in function?

0 Answers  

---

what is myisam? : Sql dba

0 Answers  

---