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 are its different types of dbms?

970

---

What is the difference between sql and isql*plus?

1025

---

What are the two types of periodical indexes?

897

---

What is column?

948

---

what are the authentication modes in sql server? How can it be changed? : Sql dba

1345

---

Why truncate is used in sql?

953

---

what is the difference between inner and outer join? Explain with example. : Sql dba

988

---

What is synonyms?

1007

---

When can we use the where clause and the having clause?

982

---

what are the type of locks ? : Sql dba

916

---

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

1102

---

What is %type in pl sql?

934

---

What are all ddl commands?

1032

---

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1051

---

What is the file extension for sql database?

957

---