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 |
Write a query to find the name of employees those who have joined on Monday.(based on column hire_date)
what is clause? : Sql dba
Can a foreign key have a different name?
What is pl/sql tables?
How to add a column ‘salary’ to a table employee_details?
What is sql partition function?
What are the attributes of SQL*PLUS ?
2 Answers Dream Careers, Oracle,
What is sql keyword?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
in sql table follw columns r their vehicle_no|servicetype|date|location| 1234 |1FS |1-JAN|PUNE| 4561 |2FS |5-JAN|PUNE| 1234 |PS |7-JAN|PUNE| 1234 |PS |15-JAN|MUMB| i want o/p below vehicleno|1fs|1fsdate|1fslocation|1ps|1PSDATE|1PSLOC|2PS|2PS DATE|2PSLOCA e.g 1234|1FS|1JAN|PUNE|1PS|7JAN|PUNE|2PS|15JAN|MUMBAI PLS help me out to execute using sql query
How do I run a pl sql procedure in sql developer?
is it possible to pass an object or table to a procedure as an argument?