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
Explain user account with reference to oracle.
What is oracle latest version?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
What are triggers in oracle?
What happens in oracle commit?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How to experiment a data lock in oracle?
What are the roles of dba?
State the difference between a primary key and foreign key?
how to join query for one source type is oracle another source type is sql server ?
Write a trigger example in oracle?
Explain alias?
What is the oracle implicit cursor?
What is a cursor variable?
What is blob datatype?