根据表查询索引信息

SELECT     ui.table_name,     ui.TABLE_TYPE,     ui.INDEX_NAME,     ui.INDEX_TYPE,     uic.TABLE_OWNER,     wm_concat (uic.COLUMN_NAME) columns FROM     dba_indexes ui,     dba_IND_COLUMNS uic WHERE     ui.INDEX_NAME (+) = uic.INDEX_NAME AND ui.INDEX_NAME = UPPER ('IDX_FOR_OFF_ONOFFLINEID') GROUP BY     ui.table_name,     ui.TABLE_TYPE,     ui.INDEX_NAME,     ui.INDEX_TYPE,     uic.TABLE_OWNER;

SELECT     ui.table_name,     ui.TABLE_TYPE,     ui.INDEX_NAME,     ui.INDEX_TYPE,     uic.TABLE_OWNER,     wm_concat (uic.COLUMN_NAME) columns FROM     dba_indexes ui,     dba_IND_COLUMNS uic WHERE     ui.INDEX_NAME (+) = uic.INDEX_NAME AND ui.TABLE_NAME = UPPER ('IDX_FOR_OFF_ONOFFLINEID') GROUP BY     ui.table_name,     ui.TABLE_TYPE,     ui.INDEX_NAME,     ui.INDEX_TYPE,     uic.TABLE_OWNER;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28572479/viewspace-2132741/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28572479/viewspace-2132741/