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 can I create database in oracle?

1066

---

How to select some rows from a table in oracle?

1123

---

What is the data type of dual table?

1062

---

When do you get a .pll extension in oracle? Explain its importance

1097

---

How to start a specific oracle instance?

1079

---

What is Reduced List of Values?

2242

---

Why do we need integrity constraints in a database?

1073

---

How to define a sub function?

1198

---

How to define a variable to match a table column data type?

1033

---

how to clone 9i Database on to 10g Database.

2383

---

What is background process in Oracle?

1138

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1746

---

How many categories of data types in oracle?

1073

---

What is the use of oracle?

1075

---

What is not equal to in oracle?

1047

---