Answer Posted / su
we can use USER_INDEXES or DBA_INDEXES
sql> desc user_indexes
index_name
index_type
table_owner
table_name
table_type
and plenty of other columns
sql>SELECT index_name
FROM user_indexes
WHERE table_name = 'EMP';
will give us the index_name, which is how we identify an
index
:) hope this helps
Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Give the various exception types.
What is the usage of control file in oracle?
Explain an index?
Explain the use of rows option in imp command.
How to define an anonymous block?
How data locks are respected in oracle?
How to create a single index for multiple columns?
How much memory your 10g xe server is using?
How can we find out the duplicate values in an oracle table?
What is sequence?
How to get execution statistics reports on query statements?
How many types of segments in Oracle?
Differentiate between translate and replace?
What is ordinary table in oracle?
What is primefaces used for?