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

Home -> Community -> Usenet -> c.d.o.server -> Re: OCP preparation...

Re: OCP preparation...

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Fri, 14 Feb 2003 00:30:28 +1000
Message-ID: <aPM2a.46787$jM5.117392@newsfeeds.bigpond.com>


"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:b2g1ca$dkm$1$8300dec7_at_news.demon.co.uk...
>
> Richard,
>
> If you read the manual (9.2 SQL Ref, Alter Table)
> you will find that the tram tracks show quite clearly
> that
>
> alter table T1 modify (n1 constraint t1_pk primary key);
>
> is perfectly valid syntax for modifying a column to add an
> inline constraint (see p7-7 for inline constraints).
>
> The fact that this does not work in practice is totally
> irrelevant - it works in theory.
>

Hi Jonathan,

You can't believe all you read.

For example, I read an extract from an English paper that Australia had absolutely no chance of beating England in the football international.

Like I said, you just can't believe all you read ...

Cheers ;)

Richard Received on Thu Feb 13 2003 - 08:30:28 CST

Original text of this message

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