Home » PL/SQL MCQs

Which of the following is the correct syntax to declare explicit cursor?

90. Which of the following is the correct syntax to declare explicit cursor?

1. CURSOR IS name
   SELECT statement;

2. CURSOR name is
   Statement SELECT;

3. Name IS CURSOR
   SELECT statement;

4. CURSOR name IS
   SELECT statement;

Answer: D)

CURSOR name IS
SELECT statement;

Explanation:

The correct syntax to declare explicit cursor is –

CURSOR name IS
SELECT statement;