Answer / anithaletchumi

select index_name from dba_indexes where table_name=upper
('table_name');

dba_indexes -> This view has the description for all
indexes in the database.

Answer / urmi

select index_name from user_indexes u where u.TABLE_NAME=upper('table_name');

what is kernel?

2 Answers   Microsoft,

---

What privilege is needed for a user to query tables in another schema?

0 Answers  

---

Write query to fetch second maximum salary from employee table.

4 Answers   Bravura Solutions, HCL,

---

What is a oracle database?

0 Answers  

---

What are the advantages of Views ?

3 Answers  

---

How to use values from other tables in update statements using oracle?

0 Answers  

---

What is integrity and what is constraint??Explain with example

0 Answers   Google,

---

can you explain performance tunning in oracle(sql,PL/SQL)

2 Answers  

---

what are the default admin accounts in Oracle 10g ?

0 Answers   MCN Solutions,

---

How to empty your oracle recycle bin?

0 Answers  

---

I have a table like this Table Name:Products Productid Price 1 10 1 10 2 20 3 30 3 30 But i want to output like this. productid price 2 20. please replay me.

3 Answers   TCS,

---

17. Display the order number and average item cost for each order.

1 Answers   Wipro,

---