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;

Write a syntax for update query in oracle?

1034

---

interview questions with answer for cts

2582

---

What is an oracle transaction?

1145

---

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

1026

---

What is redo log?

1064

---

What is not equal to in oracle?

1001

---

Why do we use coalesce function in oracle?

1118

---

Is oracle a relational database?

916

---

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

1109

---

What is a subquery?

1121

---

Explain an exception?

993

---

State and explain about oracle instance?

991

---

Can we convert a date to char in oracle and if so, what would be the syntax?

1015

---

How to initialize variables with default values?

1240

---

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2321

---