Path: news.netfront.net!newsgate.cuhk.edu.hk!border2.nntp.dca.giganews.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newscon02.news.prodigy.net!prodigy.net!newsdst01.news.prodigy.net!prodigy.com!postmaster.news.prodigy.com!newssvr23.news.prodigy.net.POSTED!0ddd666a!not-for-mail
Newsgroups: comp.databases.oracle.server
From: spambait@milmac.com (Doug Miller)
Subject: Primary key question
X-Newsreader: News Xpress 2.01
Lines: 12
Message-ID: <0mnsj.57441$Pv2.50537@newssvr23.news.prodigy.net>
NNTP-Posting-Host: 12.186.80.1
X-Complaints-To: abuse@prodigy.net
X-Trace: newssvr23.news.prodigy.net 1202848252 ST000 12.186.80.1 (Tue, 12 Feb 2008 15:30:52 EST)
NNTP-Posting-Date: Tue, 12 Feb 2008 15:30:52 EST
Organization: AT&T http://yahoo.sbc.com
X-UserInfo1: FKPO@SVEYJUABPXXKROD]V@APZXTPO\MAPVZKB]MPXHBTWICYFWUQBKZQLYJX\_ITFD_KFVLUN[DOM_A_NSYNWPFWNS[XV\I]PZ@BQ[@CDQDPCL^FKCBIPC@KLGEZEFNMDYMKHRL_YYYGDSSODXYN@[\BK[LVTWI@AXGQCOA_SAH@TPD^\AL\RLGRFWEARBM
Date: Tue, 12 Feb 2008 20:30:52 GMT
X-Original-Bytes: 1462
Xref: news.netfront.net comp.databases.oracle.server:182381

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?