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
What is not equal to in oracle?
What is MTTR advisor in Oracle?
How to use in conditions in oracle?
How to use "if" statements on multiple conditions?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
What is sequence?
Explain the difference between a procedure and a function? What do you understand by those terms?
What is the difference between sharding and replication?
How to define a variable to match a table column data type?
How can I get column names from a table in oracle?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
How to write date and time literals in oracle?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
How to select all columns of all rows from a table in oracle?
How to retrieve data from an explicit cursor?
