adspace


How to open a cursor variable?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is oracle latest version?

1174


How to use values from other tables in update statements using oracle?

1158


Design database draw er diagram for a certain scenario ?

4656


How to start an oracle instance?

1103


Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1956


How to write a left outer join with the where clause in oracle?

1155


How to select all columns of all rows from a table in oracle?

1132


How to put more than 1000 values into an oracle in clause?

1115