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 use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

1748

---

How can we force the database to use the user specified rollback segment?

830

---

How to get last row id?

754

---

What is using clause and give example?

815

---

What is proxy method?

738

---

Explain overloading. Can functions be overloaded?

793

---

Which is better Oracle or MS SQL? Why?

5874

---

what are archived logs?

1954

---

How index is implemented in oracle database?

781

---

How to check database size in Oracle?

857

---

What is null value in oracle?

838

---

How to increment dates by 1 in oracle?

780

---

How can I see all tables in oracle?

740

---

How to create id with auto_increment on oracle?

754

---

How can I introduce multiple conditions in like operator?

744

---