Multiple choice technology programming languages

What can be implemented to reuse a cursor definition in PL/SQL?

  1. Cursor FOR loop

  2. FETCH statement

  3. %ISOPEN attribute

  4. Parameters
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

PL/SQL cursors can accept parameters, making them reusable with different values each time they're opened. Parameterized cursors allow you to write the cursor definition once and open it multiple times with different parameter values, avoiding code duplication.

Keep practicing — related questions