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

How to select all columns of all rows from a table in oracle?

1055

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2270

---

How to create an oracle database?

1053

---

How to store pictures on to the database?

979

---

What are the tools for Oracle ?

1070

---

Can we connect to ORACLE db using Windows Authentication?

1264

---

How can I introduce multiple conditions in like operator?

991

---

What is oracle rowcount?

1090

---

How to empty your oracle recycle bin?

1027

---

How much memory your 10g xe server is using?

1106

---

Is insert autocommit in oracle?

1075

---

What are temporal data types in oracle?

1128

---

Explain a segment?

1093

---

Explain do view contain data?

1016

---

What is backup in Oracle?

1008

---