Answer Posted / santosh kumar

declare
type str is table of number index by binary_integer;
tab_res str; ---------declaring variable....
min_eid number;
max_eid number;
begin
select min(employee_id),max(employee_id) into
min_eid,max_eid
from employees;
for i in min_eid..max_eid loop
select salary into tab_rec(i) from employees
where employee_id=i;
end;

How do I find the database name in oracle?

1037

---

What do you mean by redo log file mirroring?

1030

---

How to turn on or off recycle bin for the instance?

1083

---

What are privileges and grants?

1066

---

please explain.. DB architecture ...

2018

---

What privilege is needed for a user to create tables in oracle?

953

---

What is an oracle database table?

1015

---

How to create a new view in oracle?

1078

---

How do I uninstall oracle 11g?

1117

---

State all possible different index configurations a table can possibly have?

996

---

What is Virtual Private Database in Oracle?

1087

---

How to save query output to a local file?

1026

---

What are the limitations oracle database 10g xe?

1046

---

Is a rollback possible to any savepoint?

1094

---

What is oracle thin client?

1023

---