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

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1223

---

Is sql pronounced sequel or sql?

1269

---

What is sql dialect?

1120

---

How do I view a procedure in sql?

973

---

Which command is used to delete a package?

1173

---

How to pipe multiline string to isql?

1007

---

Describe types of sql statements?

1058

---

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

1020

---

When should I use nosql database?

1008

---

How can check sql version from command line?

1087

---

Is a view faster than a stored procedure?

970

---

What are the 3 modes of parameter?

1154

---

What does partition by mean in sql?

962

---

What is the difference between sql and mysql?

1117

---

what is the difference between sql and t-sql? : Transact sql

1085

---