Re: When DO You Use a Semicolon?

From: Eugenie M. <gen_at_rfc.ru>
Date: Wed, 6 Aug 2003 12:44:59 +0400
Message-ID: <bgqfbg$n6n$1@news.rinet.ru>

1515981235
> Why does this occur, and when should I use the semicolon? Oracle server
> is version 8.1.7.4.0.

Hi!

There are 2 different kinds of instructions: SQL instruction and PL/SQL instruction.
For instance, SQL instruction

SELECT bla-bla                    FROM dual

PL/SQL instruction
SELECT bla-bla INTO string FROM dual;

If SQL instruction ends with semicolon, it interprets as PL/SQL instruction, otherwise as SQL (DDL or DML) instruction.

Just try to understand what is your instruction? :-)

Regards,
Eugenie Received on Wed Aug 06 2003 - 03:44:59 CDT