日期:2014-05-17 浏览次数:21031 次
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
------解决方案--------------------
用户对应索引的表的列。