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 the difference between post-database commit and post-form commit?

1179

---

List the various oracle database objects?

1048

---

How can I introduce multiple conditions in like operator?

981

---

What is ASM (Automatic Storage Management) in Oracle?

1186

---

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1060

---

How to view the tablespaces in the current database?

969

---

What is SQL access advisor in Oracle?

1182

---

Difference between the “verify” and “feedback” command?

1358

---

What is a schema in oracle?

1008

---

State the difference between a primary key and foreign key?

928

---

why dont we assign not null constraint as table level constraint.

2729

---

How to rename an existing table?

1118

---

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2205

---

How to use null as conditions in oracle?

1070

---

How to create a new tablespace in oracle?

976

---