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 logical backup in oracle?

967

---

What are the uses of a database trigger?

926

---

How to use windows user to connect to the server?

934

---

State the difference between a primary key and foreign key?

886

---

How to start an oracle instance?

951

---

How to create a new tablespace in oracle?

932

---

How to assign values to variables?

1043

---

How to define and use table alias names in oracle?

883

---

What is a trigger and what are its types in oracle?

998

---

How to use like conditions in oracle?

994

---

Define oracle database

991

---

Explain implicit cursor.

960

---

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1810

---

What is a nvl function?

956

---

How do I connect to oracle?

974

---