/* *************************************************************
*/
/* Oracle中列出指定数据表的全部索引列 */
/* */
/* *************************************************************
*/break on index_name skip 1
col index_name format a30
col uniuenes format a12
col column_name format a30
prompt Indexes for table: &&1
select c.index_name, i.uniqueness, c.column_name
from user_indexes i, user_ind_columns c
where i.index_name = c.index_name
and i.table_name = upper('&&1')
order by c.index_name, c.column_position
*/
/* Oracle中列出指定数据表的全部索引列 */
/* */
/* *************************************************************
*/break on index_name skip 1
col index_name format a30
col uniuenes format a12
col column_name format a30
prompt Indexes for table: &&1
select c.index_name, i.uniqueness, c.column_name
from user_indexes i, user_ind_columns c
where i.index_name = c.index_name
and i.table_name = upper('&&1')
order by c.index_name, c.column_position
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/90618/viewspace-621208/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/90618/viewspace-621208/