Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Empty lines in CREATE TABLE statement?

Re: Empty lines in CREATE TABLE statement?

From: Klaus Zeuch <KZeuchnospam_at_hotmail.com>
Date: Fri, 9 Mar 2001 16:56:32 +0100
Message-ID: <98b26v$n9c$1@papyrus.erlm.siemens.de>

Isn't this sufficient?

SQL> create table foo (
  2 a number
  3 /*
  4 your comment goes here
  5 */
  6 , b number);

Table created.

Klaus

Heiko Gottschling <gottschl_at_in.tum.de> schrieb in im Newsbeitrag: 98at58$bm1$03$1_at_news.t-online.com...
> Hi,
>
> the following CREATE TABLE statement works fine when executed in SQLPLUS:
>
> CREATE TABLE test (
> a NUMBER,
> b NUMBER
> );
>
> However, if I insert an empty line between the column definitions, I get
 an
> error message:
>
> CREATE TABLE test (
> a NUMBER,
>
> b NUMBER
> );
>
> >SP2-0042: unknown command "b NUMBER" - rest of line ignored.
> >SP2-0042: unknown command ")" - rest of line ignored.
>
> I find this very annoying, since I need to add some comments in the table
> definition, and not being able to insert empty lines clutters the code :-(
>
> Is this behavior a bug or a feature, and is there a way to turn it off (=
> treat newlines as normal whitespace)?
>
> thx
> Heiko
>
Received on Fri Mar 09 2001 - 09:56:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US