Multiple choice technology databases

How do you execute an anonymous block within SQL*Plus?

  1. exec command

  2. / command

  3. execute command

  4. None of these

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In SQL*Plus, an anonymous PL/SQL block (which ends with 'END;') is not executed until the buffer is flushed. The forward slash '/' on a new line tells SQL*Plus to execute the command currently in the buffer.