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

Difference between hot backup vs. Cold backup?

988

---

How to convert characters to dates in oracle?

1091

---

What is a cursor in oracle?

1170

---

How to connect ms access to oracle servers?

999

---

Explain an extent?

1095

---

Calculate difference between 2 date / times in oracle sql?

1040

---

What is raw datatype in oracle?

1130

---

What is bulk collect in oracle?

994

---

how to make an oracle object

2352

---

How to use windows user to connect to the server?

986

---

How to assign a tablespace to a users in oracle?

1046

---

How to use in conditions in oracle?

1054

---

what is port in oracle? how is it related to database application.

1943

---

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

969

---

How many types of table in Oracle?

1119

---