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;

How to select some rows from a table in oracle?

1018

---

Write a syntax for update query in oracle?

978

---

How do I manually create a database in oracle?

968

---

what is the difference between substr and instr function in oracle?

1042

---

State all possible different index configurations a table can possibly have?

954

---

Explain alias?

1087

---

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

1994

---

How to create additional tablespaces for an new database?

977

---

How to define a variable to match a table column data type?

943

---

What is the implicit cursor in oracle?

1044

---

How do I uninstall oracle 11g?

1048

---

Explain about achiever in sql?

981

---

What privilege is needed for a user to create indexes in oracle?

973

---

What happens if you lost a data file?

988

---

What is rowid and rownum in oracle?

961

---