Which of the following is used to execute a SQL statement from the SQL buffer?

Question

Options

• AEntering an asterisk (*)
• BPressing [RETURN] once
• CPressing [RETURN] twice
• DEntering a slash (/)
• EPressing [ESC] twice.

• A
  15% (4)
• B
  8% (2)
• C
  4% (1)
• D
  73% (19)

Explanation

A SQL statement or a PL/SQL block can be executed by entering a semicolon (;) or a slash (/), or by using the RUN command at SQL prompt. When a semicolon (;) is entered at the end of a command, the command is completed and executed. When a slash (/) is entered, the command in the buffer is executed. It can also be used to execute a PL/SQL block. The RUN command is used to execute a command in the buffer. Note: The SQL buffer stores the most recently used SQL commands and PL/SQL blocks. It does not store SQL* Plus commands. It can be edited or saved to a file. Note: A SQL command can be saved in the buffer by entering a blank line.

No community discussion yet for this question.