Single SQL statement in string, do not include any semicolon at end - SQL Operations

Q.  When building up a single SQL statement in a string, do not include any semicolon at the end.
- Published on 01 Jul 15

a. Yes
b. No

ANSWER: Yes
 
When we are building a single statement we need not add a semicolon at the end but if we are creating an PL/SQL block then we should add a semicolon at the end of each statement.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)