How to open a cursor variable?
- 1 Answers
- 1116 Views
- I also Faced
- E-Mail Answers
Answer / Gaurav Kumar
To open a cursor variable in Oracle PL/SQL, you can use the OPEN keyword followed by the name of the cursor variable. For example: DECLARE my_cursor SYS_REFCURSOR; OPEN my_cursor; This creates and opens a ref cursor named 'my_cursor'.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a cursor variable?
Explain the different normalization forms?
What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
can you explain performance tunning in oracle(sql,PL/SQL)
How to specify default values in insert statement using oracle?
How to list all tables in your schema?
What is the difference between an Oracle Schema and an Oracle Instance?
What is the difference between pre-select and pre-query?
What is the use of Redo Log Information ?
Shall I get Pro*C Compiler in Oracle-10g release ?
What is the database name in oracle?
How to convert characters to times in oracle?
Oracle General 
