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 basic structure of pl sql?

490

---

How do you optimize a stored procedure in sql?

494

---

What is the difference between clustered and non-clustered index in sql?

511

---

How does stored procedure reduce network traffic?

533

---

What is example of database?

511

---

---

What is latest version of sql?

517

---

What is interval partition?

537

---

Differentiate between syntax and runtime errors.

633

---

how to convert dates to character strings? : Sql dba

531

---

What is procedure explain with program?

545

---

What is compiled query?

508

---

Explain the order of sql statement execution?

602

---

What does data normalization mean?

525

---

Why use subqueries instead of joins?

593

---

What is program debugging?

552

---