Multiple choice

Which of the following statements is FALSE regarding 'Parameters in Cursor' (Parameterized Cursor)?

  1. The mode of a parameter can be both IN and OUT.

  2. A cursor parameter can be assigned a default value.

  3. The scope of the cursor parameter is local to the cursor.

  4. We can only specify the datatype of the parameter, not its length.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Parameterized cursors are static cursors that can accept passed-in parameter values when they are opened. The mode of parameter passed to a cursor can only be IN. The syntax for opening a parameterized cursor is open cursor_name(value)

Example: open mycursor(1000); where 1000 is the parameter value

Keep practicing — related questions