Re: OCP preparation...

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Sun, 9 Feb 2003 23:46:12 +1000
Message-ID: <PNr1a.44009$jM5.111263@newsfeeds.bigpond.com>

"Lukasz Feldman" <lukasz_at_atm.com.pl> wrote in message news:b2048j$a1q$1_at_portraits.wsisiz.edu.pl...
> Hi!
>
> I am preparing for first OCP exam 1Z0-007. I decided to use as a helping
> tutorial book: "Oracle OCA Oracle 9i Associate DBA Certification Exam
Guide"
> from OraclePress/Osborne (ISBN 0-07-222536-X)
> In Chapter 5 in Two Minutes Drill I found a sentence with makes me a
little
> confused:
>
> "PRIMARY KEY constraint can be added with a table constraint definition by
> using the alter table add (constraint constraint_name primary key
> (column_name)) statement or with a column constraint definition by using
the
> alter table modify (column_name constraint constraint_name primary key)
> statement"
>
> In my opinion based on SQLPlus practice experience alter table modify
> command shouldn't be used for adding primary key even as a column
> constraint. Am I right? Maybe I missed something...
>

Hi Lukasz,

No, you're not missing anything.

I too would like to see how one adds a PK by modifying a column.

Cheers

Richard Received on Sun Feb 09 2003 - 07:46:12 CST