-
DESC in primary key
Does anyone know of a way to have a DESC function on a column in a primary key? Below is what I've tried and the results:
create table tab1 (col1 number, col2 number, col3 number);
alter table tab1 add constraint pk1 primary key (col1) using index
(create index indx1 on tab1 (col1 desc));
alter table tab1 add constraint pk1 primary key (col1) using index
*
ERROR at line 1:
ORA-01418: specified index does not exist
I've also tried:
create unique index indx1 on tab1 (col1 desc);
alter table tab1 add constraint pk1 primary key (col1) using index indx1;
with the same results.
Any ideas?
Thanks,
J
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|