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 to insert the image in table

2 Answers  

---

what are pseudocolumns?

4 Answers  

---

Explain the relationship among Database, Tablespace and Data file?

4 Answers  

---

What is a read only transaction in oracle?

0 Answers  

---

Is there a function to split a string in plsql?

0 Answers  

---

Calculate difference between 2 date / times in oracle sql?

0 Answers  

---

How to rename an index?

0 Answers  

---

How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.

2 Answers   AppLabs,

---

what is the use of composite key constraint?

2 Answers  

---

What are ACID properties in databases?

1 Answers  

---

What is oracle open database communication (odbc)?

0 Answers  

---

How to create a table interactively?

0 Answers  

---