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 |
if a table is getting updated what happens if a function is called from sql query?
What are two parts of package ?
What is trigger with example?
Write one update command to update seqno field of a table on the basis of row number.
What are sql functions? Describe in brief different types of sql functions?
what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table...
What are the pre requisites?
What is user defined functions?
What are crud methods?
What is user in sql?
What is the main difference between sql and pl/sql?
can we create index on index?