For a single SQL statement you cannot use a semi-colon to terminate it.

For a PL/SQL Block with multiple SQL statements you need to terminate each SQL statement in the block with a semi-colon, as well as the "end;" of the PL/SQL Block itself.