Primary key question
Date: Tue, 12 Feb 2008 20:30:52 GMT
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