Re: descending/ascending in user_ind_columns

On Sun, 8 Nov 1998 20:34:34 +0100, "BOVBOV" <BOVBOV_at_aol.com> wrote:

>Hi !
>
>In which system table can I find the information if an index
>column is ascending or descending sorted ?
>
>In user_ind_columns there is no hint to this.
>
>Thanks.
>
>

Oracle doesn't have descending indexes. This has been removed from Oracle 7 in conformance with the ANSI standards. It will however start at the end of ascending index if necessary (index_column <= a certain value)

Hth, Received on Mon Nov 09 1998 - 01:22:33 CST