good eye tom :)
randy
Thomas Kyte wrote:
>
> A copy of this was sent to bmlam <bmlam_at_online.de>
> (if that email address didn't require changing)
> On Mon, 29 Nov 1999 14:06:00 +0100, you wrote:
>
> >After some sweating and swearing I finally managed to define an index
> >organized table from SQLPLUS. It took me more than 1 dozen tries, below
> >is an excerpt that demonstrates the problem I encountered:
> >
> >create table book_index
> > 2 ( keyword varchar2(40),
> > 3 pg_no number(4),
> > 4 constraint book_index_pk primary key (keyword))
> > 5 organization index
> > 6 tablespace usr
> > 7 pctthreshhold 30
> > 8 overflow tablespace usr;
> >pctthreshhold 30
> >*
> >ERROR at line 7:
> >ORA-00933: SQL command not properly ended
> >
> >SQL> create table book_index
> > 2 ( keyword varchar2(40),
> > 3 pg_no number(4),
> > 4 constraint book_index_pk primary key (keyword))
> > 5 organization index
> > 6 tablespace usr pctthreshold 30 overflow tablespace usr;
> >
> >Table created.
> >
> >Where the hick is any syntax difference between the two statements
> >besides the line breaks?
>
> the double H in "pctthreshhold" is the difference between the 2. You have a
> typo in the first create table "pctthreshhold" <> "pctthreshold"
>
> >And I though SQL is supposed to be free format. Having said that, I'd
> >like to avoid situations like that again in the future. Could someone
> >please shed some light into this mysterious "bug"?
>
> --
> See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
> Current article is "Part I of V, Autonomous Transactions" updated June 21'st
>
> Thomas Kyte tkyte_at_us.oracle.com
> Oracle Service Industries Reston, VA USA
>
> Opinions are mine and do not necessarily reflect those of Oracle Corporation
Received on Tue Nov 30 1999 - 13:10:08 CST
