Can we use SQL%ISOPEN in implicit cursors? Does this
attribute works properly in Implicit Curosors?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / pradeep naidu manne tcs
IMPLICIT CURSORS ARE OPENED N CLOSED IMPLICITLY SO SQL%FOUND WILL ALWAYS EVALUATES FALSE
Is This Answer Correct ? | 4 Yes | 0 No |
Which is faster count (*) or count 1?
What is the most restrictive isolation level? : Transact sql
What is not in sql?
How do you determine the current isolation level? : Transact sql
What is scope and visibility in PL/SQL?
What is mutating table?
what is the difference between pragma exception_init and raise_application_error
1 Answers Aetins, State Street,
The in operator may be used if you know the exact value you want to return for at least one of the columns.
How to order siblings in oracle hierarchy queries?
can sql servers linked to other servers like oracle? : Sql dba
Which software is used for pl sql programming?
What are Lexical Parameters.How They are used in Reports 6i