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