Re: no semicolon in SQL*PLUS

From: Alan Mills <Alan.Mills_at_nospamservices.fujitsu.com>
Date: Thu, 31 Oct 2002 15:19:10 -0000
Message-ID: <aprhle$1i66$1@news.icl.se>

Maybe he was running the SQL in a GUI tool that doesn't actually require the trailing semi-colon and so it was in fact the semi-colon that was considered the invalid character. Doesn't SQL*Navigator do that in the sngle SQL window?

I still reckon you want VARCHAR2s rather than VARCHARs though, as per Oracle documentation.

"Brian Peasland" <oracle_dba_at_peasland.com> wrote in message news:3DC13B70.F7CBB1CC_at_peasland.com...
> ORA-911 is an invalid character. But I don't get that from your code:
>
> ORA9I SQL> CREATE TABLE Calling_Card
> 2 (
> 3 Company_Name VARCHAR(25),
> 4 Card_Number VARCHAR(25),
> 5 Starting_Value NUMBER(4,2),
> 6 Value_Left NUMBER(4,2),
> 7 Pin_Number VARCHAR(12)
> 8 )
> 9 ;
>
> Table created.
>
>
> As you can see, it worked just fine for me.
>
> HTH,
> Brian
>
> liglin wrote:
> >
> > 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 - 09:19:10 CST