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
List out the types of joins.
How to load excel data sheet to oracle database
What is the dynamic sql in oracle?
How to export data with a field delimiter?
What is the difference between a hot backup and a cold backup in oracle?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
How to calculate date and time differences in oracle?
How to get the Installed Oracle Version Information ?
Write a syntax for update query in oracle?
what is the difference between functional dependecy and multilevel dependency?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
Why do we need oracle client?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
How to export your own schema?
1) Does oracle have any table which contain all the exceptions and it's code internally?
