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 write create command in the plsql block?if possible how?

2 Answers  

---

What is pl sql architecture?

0 Answers  

---

what is the order of pre-defined exceptions.

6 Answers   TCS,

---

Write an sql query to select all records from the table?

0 Answers  

---

what is self join and how it works??

2 Answers   Infosys,

---

What is difference between joins and union?

0 Answers  

---

What data types does pl/SQL have?

3 Answers  

---

What is sp_helptext?

0 Answers  

---

Is sql easier than java?

0 Answers  

---

Explain what is a database?

0 Answers  

---

Why is a primary key important?

0 Answers  

---

How do I write a cron which will run a sql query and mail the results to agroup?

0 Answers  

---