cursordeclaration used for declaring an explicit cursor - PL/SQL Elements

Q.  Which keyword and parameter used for declaring an explicit cursor?
- Published on 08 Jul 15

a. constraint
b. cursor_variable_declaration
c. collection_declaration
d. cursor_declaration

ANSWER: cursor_declaration
 
cursor_declaration

cursor - This means it will have the name of the explicit cursor that we are declaring and will define it later in the same block,subprogram or package. It can be any identifier except for the reserved words. It follows the same scoping rules as the variables.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)