Answer Posted / 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 column? : Sql dba

1000

---

What is the maximum size of sqlite database?

1101

---

What are views in sql?

975

---

Why is theta join required?

1139

---

What is bitemporal narrowing?

1297

---

how to load data files into tables with 'mysqlimport'? : Sql dba

1091

---

How do you remove duplicate records from a table?

936

---

Do stored procedures prevent sql injection?

963

---

How are sql commands classified?

1080

---

How do you declare a constant?

958

---

Describe different types of general function used in sql?

1030

---

What is error ora-01000: maximum open cursors exceeded

1134

---

What are all the different normalizations?

1025

---

Are subqueries faster than joins?

1011

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

4016

---