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);

What are the numeric comparison operations?

0 Answers  

---

How to test null values?

0 Answers  

---

What is bulk copy or bcp in oracle?

0 Answers  

---

How to Truncate Table in Oracle

0 Answers   HCL,

---

What are the type of Synonyms?

1 Answers  

---

You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.

3 Answers   Amazon, HCL,

---

How to join two tables in a single query using oracle?

0 Answers  

---

Difference between sub query and nested query ?

19 Answers   Keane India Ltd, TCS,

---

What is java oracle used for?

0 Answers  

---

select statement does not retrieve any records. what exception is raised?

2 Answers  

---

what is the difference between oracle enterprise edition and oracle express edition?

2 Answers  

---

Why oracle is used?

0 Answers  

---