What Is Use Of A Cursor Variable? How It Is Defined?

1.	What Is Use Of A Cursor Variable? How It Is Defined?
Answer» A cursor variable is associated with DIFFERENT statements at RUN TIME, which can hold different values at run time. Static cursors can only be associated with one run time query. A cursor variable is reference type (like a pointer in C). Declaring a cursor variable: TYPE type_name IS REF CURSOR RETURN return_type type_name is the name of the reference type,return_type is a record type indicating the types of the select list that will EVENTUALLY be RETURNED by the cursor variable. A cursor variable is associated with different statements at run time, which can hold different values at run time. Static cursors can only be associated with one run time query. A cursor variable is reference type (like a pointer in C). Declaring a cursor variable: TYPE type_name IS REF CURSOR RETURN return_type type_name is the name of the reference type,return_type is a record type indicating the types of the select list that will eventually be returned by the cursor variable.

Answer»

A cursor variable is associated with DIFFERENT statements at RUN TIME, which can hold different values at run time. Static cursors can only be associated with one run time query. A cursor variable is reference type (like a pointer in C).

Declaring a cursor variable:
TYPE type_name IS REF CURSOR RETURN return_type type_name is the name of the reference type,return_type is a record type indicating the types of the select list that will EVENTUALLY be RETURNED by the cursor variable.

A cursor variable is associated with different statements at run time, which can hold different values at run time. Static cursors can only be associated with one run time query. A cursor variable is reference type (like a pointer in C).

What Is Use Of A Cursor Variable? How It Is Defined?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment