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 meant by joins? List out the types of joins.

1102

---

How to pass a cursor variable to a procedure?

1154

---

How to delete a column in an existing table in oracle?

1126

---

How to export your own schema?

1049

---

Explain a segment?

1127

---

What is Virtual Private Database in Oracle?

1147

---

How to convert characters to times in oracle?

1070

---

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1990

---

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

3021

---

What is dynamic proxy?

1049

---

How a database is related to tablespaces?

1081

---

What is a sub query? What are its various types?

1270

---

What is the usage of save points in oracle database?

1011

---

how to handle exceptions in post production

1482

---

What is the difference between online and offline backups?

1130

---