Re: DESC in index column

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 20 Aug 2002 15:46:11 GMT
Message-ID: <3D626437.C8932537@exesolutions.com>

Daud wrote:

> Hi
>
> If I create an index like below in 8i basically I am creating a
> function-based index. What does it do if I execute the command in prev
> release of Oracle (7.3.4, 8.0.5 etc.)? Is the DESC just ignored? Sorry
> I check since I dont have prev rel of Oracle.
>
> CREATE INDEX MyIndexName ON MyTable (MyCol DESC);
>
> rgds
> Daud

It is an error. You can not issue commands that are invalid in a database.

Daniel Morgan Received on Tue Aug 20 2002 - 10:46:11 CDT