Oracle Applicatons
Pages
Home
SQL
Forms
Oracle Apps
Others
Reports
PL/SQL
OAF
Tuesday, 10 May 2016
Query to Check to see what Indexes are on a Table
The relevant query is as follows:
SELECT index_name
FROM all_indexes
WHERE table_name = ‘<TABLE_NAME>’;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment