Re: is Oracle SQL a free format language?

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 Mon Nov 29 1999 - 07:48:47 CST