Primary key question

From: Doug Miller <>
Date: Tue, 12 Feb 2008 20:30:52 GMT
Message-ID: <0mnsj.57441$>

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 -- 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