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;

I have a CURSOR then why we need BULK COLLECT again?

1 Answers  

---

What is not equal in sql?

0 Answers  

---

How many types of index are there?

0 Answers  

---

sql query to get zero records from a table having n no of records

8 Answers   CTS,

---

When do we use triggers?

0 Answers  

---

---

Define concurrency control. : Transact sql

0 Answers  

---

Delete duplicate records in the emp table.

6 Answers   Oracle,

---

what is “go” in t-sql? : Transact sql

0 Answers  

---

What is function and procedure?

0 Answers  

---

Which normal form is best?

0 Answers  

---

Is it possible to access the current value in a session before accessing next value?

1 Answers  

---

How do you declare a variable in pl sql?

0 Answers  

---