Answer / 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;

Answer / su

declare
TYPE tab IS TABLE OF varchar2(200)
INDEX BY binary_integer;
t tab;
v_counter number : =0;
BEGIN
FOR c_emp IN (SELECT ENAME FROM emp)
LOOP
v_counter := v_counter + 1;
t(v_counter):= c_emp.ename;
END LOOP;
FOR i IN 1 .. t.last
LOOP
dbms_output.put_line(t(i));
END LOOP;
EXCEPTION
WHEN others THEN
dbms_output.put_line(sqlcode);
dbms_output.put_line(sqlerrm);
END;

Answer / sourav mukhopadhyay

Create index INDEXNAME
ON table(column-name);

How do I limit the number of rows returned by an oracle query after ordering?

0 Answers  

---

What are the numeric comparison operations?

0 Answers  

---

How many different types of indexes we have in oracle?

24 Answers   IBM, TCS,

---

How would you go about verifying the network name that the local_listener is currently using?

0 Answers  

---

How to import one table back from a dump file?

0 Answers  

---

What privilege is needed for a user to connect to oracle server?

0 Answers  

---

What is meant by redo log buffer ?

2 Answers  

---

Explain the characteristics of oracle dba?

0 Answers  

---

What is autonomous transaction?

6 Answers  

---

25. Display the client number and the value of the highest value order placed by that client.

2 Answers   Wipro,

---

what is the output of select * from emp where null=null & select * from emp where 1=1

8 Answers   IMS Health, NIIT,

---

What is a dynamic performance view in oracle?

0 Answers  

---