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;

What is proxy method?

729

---

Please explain oracle left join with an example?

772

---

How to export data with a field delimiter?

790

---

What is a named program unit?

787

---

How to do a full database export?

856

---

What is a table in oracle?

721

---

What is oracle database 10g express edition?

809

---

How remove data files before opening a database?

765

---

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

783

---

How to create a table index?

796

---

What is the use of file param in imp command?

892

---

What are the restrictions on external table columns?

800

---

What happens if you lost a data file?

802

---

how to do daily transactions with out sql* loader control file regesterd in apps?

1444

---

Differentiate between pre-select and pre-query?

838

---