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

What is parameterized cursor in oracle?

1077

---

How does Oracle guarantee data integrity of data changes?

2342

---

Explain the use of grant option in exp command.

1018

---

What are privileges and grants?

1011

---

State some uses of redo log files?

951

---

What is a lookup table in oracle?

942

---

What are the benefits of ordbms?

1032

---

What are data pump export and import modes?

1025

---

How to connect to a local oracle 10g xe server?

948

---

What is a trigger and what are its types in oracle?

1012

---

How to create a new tablespace in oracle?

940

---

Is oracle an operator?

892

---

What is oracle datasource?

932

---

What are the attributes of cursor?

997

---

What is the difference between sharding and replication?

972

---