c.constraint_type, c.search_condition,
i.index_name, column_name, descend
from user_constraints c,
user_indexes i,
user_ind_columns ic
where c.index_name = i.INDEX_NAME (+)
and c.index_name = ic.INDEX_NAME (+)
order by c.table_name, i.index_name, ic.column_position
0 件のコメント:
コメントを投稿