Re: Primary key question

Doug Miller wrote:
> Background: I have 5+ years experience in SQL on Tandem systems, but I'm an
> Oracle newbie trying to adjust to the differences in the two implementations.
>
> This would work in Tandem SQL/MP:
>
> create table abc (a char(8), b char(8), c char(8),
> primary key (a, b, c descending));
>
> but it doesn't seem to work in SQL*Plus 10.1.0.4.2 -- do I have the syntax
> wrong somehow, or does Oracle simply not support descending sequence in a
> primary key column?
>

Hi Doug,

Apart from all the stuff brought up: isn't it simply so that a relation (any relation!) does not have an order? Doesn't that make it a logical impossibility for the primary key to be ordered? (Personally, I take this to be rhetorical questions).

Regards,

Ruud de Koter. Received on Wed Feb 13 2008 - 14:33:30 CST