Multiple choice technology databases

Which character is used to continue a statement in SQL*Plus?

  1. / '

    • '
    • '
  2. = '

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

In SQL*Plus, the hyphen character (-) is used as a continuation character when placed at the end of a line. It tells SQL*Plus that the SQL statement continues on the following line, allowing you to break long statements across multiple lines for readability.

AI explanation

To answer this question, you need to understand how statements are executed in SQL*Plus.

In SQL*Plus, a hyphen (-) character is used to continue a statement onto the next line.

Option A) / ' - This option is incorrect because the forward slash (/) character is used to execute a SQL or PL/SQL statement in SQL*Plus, but it is not used to continue a statement onto the next line.

Option B) * ' - This option is incorrect because the asterisk (*) character is not used to continue a statement in SQL*Plus.

Option C) - ' - This option is correct because the hyphen (-) character is used to continue a statement onto the next line in SQL*Plus.

Option D) = ' - This option is incorrect because the equal sign (=) character is not used to continue a statement in SQL*Plus.

The correct answer is Option C) - '. This option is correct because the hyphen (-) character is used to continue a statement onto the next line in SQL*Plus.