Re: no semicolon in SQL*PLUS

From: Alan Mills <Alan.Mills_at_nospamservices.fujitsu.com>
Date: Thu, 31 Oct 2002 09:14:21 -0000
Message-ID: <apqs9d$1779$1@news.icl.se>

It's the semi-colon that is the 'trigger' (no pun intended!) to SQL*Plus to execute the command entered so you always need it.

An alternative though is the use a '/' on the last line of it's own.

Also, not related to your question but use VARCHAR2 rather than VARCHAR for your column descriptions. VARCHAR is a hangover for backwards compatibility and should not be used in any new code.

"liglin" <liglinlillibli_at_hotmail.com> wrote in message news:db9bdb31.0210310000.399bbe1a_at_posting.google.com...
> When I terminate the following SQL with a semicolon I get: ORA-00911
> in personal Oracle 9i. Can the semicolon not be used in SQL*PLUS?
>
> CREATE TABLE Calling_Card
> (
> Company_Name VARCHAR(25),
> Card_Number VARCHAR(25),
> Starting_Value NUMBER(4,2),
> Value_Left NUMBER(4,2),
> Pin_Number VARCHAR(12)
> )
>
> thx, Liglin
Received on Thu Oct 31 2002 - 03:14:21 CST