How you open and close a cursor variable.Why it is required?
Answer Posted / venkat
open cursor then the cursor points to the starting of the data......close the cursor it clears the data after the execution of a program
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to compare dates in oracle sql?
What are the limitations of check constraint?
How to increment dates by 1 in oracle?
What happens if variable names collide with table/column names?
How to create a table interactively?
Can we use bind variables in oracle stored procedure?
 What are the oracle DML commands possible through an update strategy?
What is Virtual Private Database in Oracle?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What is the maximum limit on the number of columns in a table?
How to define an anonymous procedure without variables?
How to estimate disk space needed for an export job?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
Which is faster join or subquery in oracle?
How do I limit the number of rows returned by an oracle query after ordering?