Re: no semicolon in SQL*PLUS

From: Brian Peasland <oracle_dba_at_peasland.com>
Date: Thu, 31 Oct 2002 14:17:20 GMT
Message-ID: <3DC13B70.F7CBB1CC@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 - 08:17:20 CST