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 |
how can stop the sequence with mention the max value and with out mention the max value
7. Where would you look for errors from the database design?
how to rename an existing column in a table? : Sql dba
What do you understand by pl/sql records?
where are cookies actually stored on the hard disk? : Sql dba
What do you mean by stored procedures? How do we use it?
What is a join?
What is correlated sub-query?
What found sql?
What are the sql commands?
What is sql lookup?
What are synonyms in sql?