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(:P_TABLE_NAME)
ORDER BY c.index_name, c.column_position;
FROM user_indexes i, user_ind_columns c
WHERE i.index_name = c.index_name
AND i.table_name = UPPER(:P_TABLE_NAME)
ORDER BY c.index_name, c.column_position;
No comments:
Post a Comment