额...如题..小问题.
请赐教 .
------解决方案--------------------
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
------解决方案--------------------
用户对应索引的表的列。