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

What is a proxy object?

801

---

How to create an oracle database manually?

813

---

How to create a new table in oracle?

805

---

How can I combine multiple rows into a comma-delimited list in oracle?

811

---

How to download oracle database 10g xe?

791

---

How to convert characters to times in oracle?

772

---

How do I uninstall oracle 11g?

812

---

How to assign values to data fields in record variables?

788

---

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2739

---

What is flashback in Oracle?

758

---

What is program global area (pga) in oracle?

794

---

What is varray?

804

---

What is memory advisor in Oracle?

821

---

How can you use check constraints for self referential integrity?

741

---

Explain the use of Merge statement in oracle 11g

799

---