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 are ddl statements in oracle?

1025

---

How to recover a dropped table in oracle?

988

---

Where do we use decode and case statements?

949

---

What is the difference between primary key and unique key and foreign key in oracle?

927

---

What is an anonymous block?

1172

---

What are the various oracle database objects?

1098

---

Can we insert data in view oracle?

974

---

Explain integrity constraint?

1117

---

What is control file used for?

1115

---

Is the After report trigger fired if the report execution fails ?

2879

---

What is the purpose of tables, private synonyms and public synonyms in Oracle?

995

---

Explain oracle 12c new features for developers?

1003

---

What is transaction control statement and how many types of transaction control statement in Oracle?

1090

---

How to omit columns with default values in insert statement in oracle?

1008

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2214

---