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 do you mean by merge in oracle and how can you merge two tables?

909

---

What is merge in oracle?

997

---

How to experiment a data lock in oracle?

1001

---

Explain the use of consistent option in exp command.

974

---

Please explain drop constraint oracle?

1030

---

What is format trigger?

2018

---

Give the constructs of a package, function or a procedure.

988

---

How translate command is different from replace?

1009

---

What is a proxy class?

972

---

Write a syntax for update query in oracle?

970

---

How to assign data of the deleted row to variables?

1015

---

What are the oracle differences between nvl and coalesce

1072

---

List the parts of a database trigger.

990

---

How to loop through data rows in the implicit cursor?

1016

---

How to return top 5 rows in oracle?

994

---