Oracle Apps and Oracle Database
Saturday, December 17, 2016
find Indexes created on table
Query to find the list of all indexes created on a table.
SELECT index_name, column_name, column_position
FROM dba_ind_columns
WHERE table_name like upper('&table_name')
ORDER BY index_name, column_position;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment