Answer Posted / pr@$@d

Implicit cursors: SQL%ISOPEN always returns FALSE,
indicating that the implicit cursor has been closed.

I hope below example gives you very fair idea.

SQL> BEGIN
2 UPDATE employee
3 SET salary = salary *2
4 WHERE id = '01';
5
6 IF not SQL%ISOPEN THEN
7 DBMS_OUTPUT.PUT_LINE('closed');
8 END IF;
9 END;
10 /
closed

PL/SQL procedure successfully completed.

Thanks
-Pr@$@d

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

1036

---

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1115

---

What is database sql?

1091

---

Does truncate remove indexes?

1073

---

What is pivot in sql?

964

---

How is indexing done in search engines?

1018

---

How is sql used in oracle?

1035

---

What is query optimization in sql?

1038

---

What does := mean in pl sql?

1083

---

What is the difference between a primary key and a clustered index?

1033

---

how can we submit a form without a submit button? : Sql dba

1031

---

What is data modelling in sql?

1065

---

What is %rowtype in pl sql?

1024

---

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1143

---

Which certification is best for sql?

1034

---