Can we use SQL%ISOPEN in implicit cursors? Does this
attribute works properly in Implicit Curosors?
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
Is This Answer Correct ? | 13 Yes | 6 No |
Post New Answer View All Answers
Is natural join and inner join same?
How to place comments in pl/sql?
Describe types of sql statements?
How do you pronounce sql?
Why procedure is used in sql?
Where is pl sql used?
What is natural join in sql?
How do I copy a table in sql?
What has stored procedures in sql and how we can use it?
Can there be more than one function with a similar name in a pl/sql block?
What is type and rowtype in pl sql?
which operator is used in query for pattern matching? : Sql dba
What does inner join mean?
What is sql not null constraint?
Define SQL and state the differences between SQL and other conventional programming Languages?