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;
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
How to create additional tablespaces for an new database?
What is merge in oracle?
How to retrieve values from data fields in record variables?
Why is oracle so popular?
Explain oracle left join with an example?
How to define a data source name (dsn) in odbc manager?
what is the scenario where you take the database to NoArchivelog mode?
How to create an initialization parameter file?
What happens to the current transaction if the session is ended?
1) Does oracle have any table which contain all the exceptions and it's code internally?
What are a cluster and non-cluster index?
What is a select query statement in oracle?
What is rowid and rownum in oracle?
How to use "if" statements on multiple conditions?
Explain joins in oracle?
