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 an alias command?

1114

---

Can you join views in sql?

994

---

Why we use join in sql?

1024

---

What is percent sign in sql?

1324

---

What is the difference between partition and index?

1055

---

What is data definition language?

1135

---

What is nvarchar in sql?

978

---

How many types of tables are there?

996

---

What is a schema? How is it useful in sql servers?

1174

---

Is id a reserved word in sql?

1187

---

How long will it take to learn pl sql?

979

---

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

1035

---

how to use myisamchk to check or repair myisam tables? : Sql dba

1016

---

what are the differences between require and include, include_once and require_once? : Sql dba

1068

---

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

1066

---