Answer / 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

Explain overloading. Can functions be overloaded?

0 Answers  

---

How will you differentiate between varchar & varchar2?

0 Answers  

---

How to use "if" statements on multiple conditions?

0 Answers  

---

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

0 Answers   IBM,

---

Display the records between two range?

2 Answers  

---

---

What are the tools for Oracle ?

0 Answers   Infosys,

---

what are the things that you consider while creating indexes on partitioning tables?

1 Answers  

---

Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?

6 Answers   IBM,

---

which institute and which faculty is providing best training for oracle sql, plsql in hyderabad

4 Answers  

---

What is the maximum limit on the number of columns in a table?

0 Answers  

---

How to display First 4 rows From Database Table?

6 Answers  

---

Difference between primary key and unique key ?

77 Answers   Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions,

---