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

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

4093

---

What are the types of records?

951

---

How run sql*plus commands that are stored in a local file?

973

---

How do I truncate a word?

990

---

What is t sql in sql server?

1000

---

what are the types of join and explain each? : Sql dba

989

---

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1063

---

What does over partition by mean in sql?

919

---

How do you write an index?

912

---

what is 'mysqlshow'? : Sql dba

973

---

How to Execute a Package in PL/SQL.?

1107

---

what is the different between now() and current_date()? : Sql dba

930

---

Define union, minus, union all, intersect ?

949

---

What is the purpose of normalization?

995

---

difference between anonymous blocks and sub-programs.

1077

---