Home » PL/SQL MCQs

Which of the following is the correct syntax to create the Explicit Cursor?

88. Which of the following is the correct syntax to create the Explicit Cursor?

1. IS select_statement cursor_name CURSOR;
2. CURSOR select_statement IS cursor_name;
3. CURSOR cursor_name select_statement IS;
4. CURSOR cursor_name IS select_statement;

Answer: D) CURSOR cursor_name IS select_statement;

Explanation:

CURSOR cursor_name IS select_statement; is the correct syntax to create the Explicit Cursor.