Re: Unique index

Siegfried Hempfer wrote:
>
> Is it possible with the current ORACLE release to define a unique index,
> i.e. to formulate something like CREATE UNIQUE INDEX using ORACLE SQL?
> My documentation from december 92 says no, but maybe thtis was changed
> in the last years?!CREATE TABLE TABLEA

      (TABLE_KEY                CHAR(18) NOT NULL,
       FRED                     CHAR(18) NOT NULL

CREATE UNIQUE INDEX PK_TABLEA
  ON TABLEA
(

       TABLE_KEY                      ASC

CREATE UNIQUE INDEX UK_FRED
  ON TABLEA
(

       FRED                           ASC