Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create PK with descending column order

57351Mar 21 2003 — edited Mar 24 2003

I'm trying to create a PK (constraint and index) on a table using the following:

ALTER TABLE TEST_TABLE ADD CONSTRAINT TEST_TABLE_PK
PRIMARY KEY (COLA, COLB DESC) USING INDEX...

and I getting an error. It seems that I cannot force a descending order on colb. Comments, please...

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 21 2003

Added on Mar 21 2003

#general-database-discussions

5 comments

1,307 views