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 sql and db2?

727

---

How to Declare Fixed Length String Value In PL SQL

843

---

Is big data nosql?

692

---

What is sql integrity?

781

---

What is query execution plan in sql?

773

---

---

What are the two types of periodical indexes?

660

---

Is sql open source?

713

---

Is sql easier than java?

734

---

What is sql partition function?

801

---

What is a sql schema used for?

729

---

Are stored procedures compiled?

678

---

What is the largest value that can be stored in a byte data field?

707

---

what are rollup and cube in t-sql? : Transact sql

819

---

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

812

---

Can cursors be part of a trigger body?

1349

---