Answer Posted / naresh

Yes the above answer is true, and te attributes that you
have mentioned are for explict cursor.

for implicit cursor just add SQL infront of all the attributes.

Like
SQL%isopen,
SQL%found

Cheers!
Naresh

How to define an anonymous procedure without variables?

1106

---

How many types of tables supported by oracle?

1076

---

How to drop a stored function?

1137

---

How to add a new column to an existing table with a default value?

1016

---

Explain what are the uses of rollback segment?

1013

---

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1865

---

What do you mean by cdb and pdb in oracle 12c?

1059

---

What are the differences between blob and clob in oracle?

1089

---

How to declare a local variable?

1112

---

what are the default admin accounts in Oracle 10g ?

967

---

what is the dual table in oracle?

991

---

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1846

---

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2286

---

ABOUT IDENTITY?

2057

---

Are truncate and delete commands same? If so why?

1152

---