How you open and close a cursor variable?

5 like 0 dislike

How you open and close a cursor variable.Why it is required?

asked 1 year ago by daneim (127,080 points)

1 Answer

1 like 0 dislike

Best answer

OPEN cursor variable FOR SELECT...Statement
CLOSE cursor variable In order to associate a cursor variable with a particular SELECT statement OPEN syntax is used. In order to free the resources used for the query CLOSE statement is used.

answered 1 year ago by marck_don (191,010 points)

Related questions

7 like 0 dislike

1 answer

What is use of a cursor variable? How it is defined?

asked 1 year ago by DBA-boss (120,990 points)

5 like 0 dislike

1 answer

What should be the return type for a cursor variable?

asked 1 year ago by marck_don (191,010 points)

7 like 0 dislike

1 answer

How you were passing cursor variables in PL/SQL 2.2?

asked 1 year ago by DBA-boss (120,990 points)

7 like 0 dislike

1 answer

Can cursor variables be stored in PL/SQL tables.If yes how?

asked 1 year ago by daneim (127,080 points)

5 like 0 dislike

1 answer

What is a package cursor ?

asked 1 year ago by rad_joshep (19,390 points)