Primary key question

From: Doug Miller <spambait_at_milmac.com>
Date: Tue, 12 Feb 2008 20:30:52 GMT
Message-ID: <0mnsj.57441$Pv2.50537@newssvr23.news.prodigy.net>


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?     Received on Tue Feb 12 2008 - 14:30:52 CST

Original text of this message