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

What is the difference between truncate and drop statements?

1175

---

What is difference between ms sql and mysql?

957

---

What are inner and outer joins examples of both?

951

---

What is scalar data type in pl sql?

1064

---

how would concatenate strings in mysql? : Sql dba

1083

---

What is sql mysql pl sql oracle?

1067

---

what is a unique key ? : Sql dba

1087

---

How do I edit a trigger in sql developer?

990

---

What is snowflake sql?

1069

---

What is sql performance tuning?

913

---

Mention what is the function that is used to transfer a pl/sql table log to a database table?

982

---

Is sql harder than python?

1093

---

What is mdb stand for?

1004

---

What is the difference between mdf and ndf files?

1112

---

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

1029

---