USER_IND_COLUMNS 这个表有什么作用?
额...如题..小问题.
请赐教 .

[解决办法]
user_ind_columns 用户的索引对应的表列信息

[解决办法]

SQL code

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
[解决办法]
用户对应索引的表的列。