Multiple choice technology databases

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

  1. *

  2. /

  3. -

  4. @
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The hyphen (-) is the SQL*Plus continuation character. When placed at the end of a line, it indicates that the statement continues on the next line. This allows long SQL statements to be split 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 statement can be continued onto the next line by using the hyphen ("-") character. This is known as a line continuation character.

Option A) * - This character is not used to continue a statement in SQL*Plus. Option B) / - This character is used to execute a statement in SQL*Plus, but it is not used to continue a statement onto the next line. Option C) - This character is the correct answer. It is used to continue a statement onto the next line in SQL*Plus. Option D) @ - This character is used to run a script or a file in SQL*Plus, but it is not used to continue a statement onto the next line.

The correct answer is Option C) -. This character is used to continue a statement in SQL*Plus.

Keep practicing — related questions