USER_IND_COLUMNS describes the columns of indexes owned by the current user and columns of indexes on tables owned by the current user. This view does not display the INDEX_OWNER or TABLE_OWNER columns.SQL> desc user_ind_columns; Name Type Nullable Default Comments --------------- -------------- -------- ------- --------------------------------------------------------------- INDEX_NAME VARCHAR2(30) Y Index name TABLE_NAME VARCHAR2(30) Y Table or cluster name COLUMN_NAME VARCHAR2(4000) Y Column name or attribute of object column COLUMN_POSITION NUMBER Y Position of column or attribute within index COLUMN_LENGTH NUMBER Y Maximum length of the column or attribute, in bytes CHAR_LENGTH NUMBER Y Maximum length of the column or attribute, in characters DESCEND VARCHAR2(4) Y DESC if this column is sorted descending on disk, otherwise ASC
owned by the current user. This view does not display the INDEX_OWNER or TABLE_OWNER columns.SQL> desc user_ind_columns;
Name Type Nullable Default Comments
--------------- -------------- -------- ------- ---------------------------------------------------------------
INDEX_NAME VARCHAR2(30) Y Index name
TABLE_NAME VARCHAR2(30) Y Table or cluster name
COLUMN_NAME VARCHAR2(4000) Y Column name or attribute of object column
COLUMN_POSITION NUMBER Y Position of column or attribute within index
COLUMN_LENGTH NUMBER Y Maximum length of the column or attribute, in bytes
CHAR_LENGTH NUMBER Y Maximum length of the column or attribute, in characters
DESCEND VARCHAR2(4) Y DESC if this column is sorted descending on disk, otherwise ASC