Snippet Name: List all indexed columns for a given table
Description: Easy way to list all indexed columns for a given table.
Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 02nd, 2009
break ON index_name skip 1
col index_name format a30
col uniuenes format a12
col column_name format a30
prompt Indexes FORTABLE: &&1SELECT 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')ORDERBY c.index_name, c.column_position
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.