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

How to delete multiple rows from a table in oracle?

1003

---

How to assign data of the deleted row to variables?

1013

---

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2173

---

What to do if dba lost the system password?

1087

---

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

948

---

What are the differences between date and timestamp in oracle?

973

---

How data locks are respected in oracle?

1009

---

can u plz provide me oca sql dumps please i need them

1900

---

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

2213

---

Can you drop an index associated with a unique or primary key constraint?

967

---

What is an oracle cursor variable?

1005

---

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1943

---

Is there a combination of "like" and "in" in sql?

1004

---

What is program global area (pga) in oracle?

957

---

What do you understand by a database object? Can you list a few of them?

970

---