Answer Posted / manish rathore

I got it from net.
Hope it will serve.

select *
from sys.dm_db_index_usage_stats
where object_id = object_id( '<Table_Name>' )

How to retrieve data from an cursor to a record?

1073

---

Why cursor variables are easier to use than cursors?

1065

---

What is the usage of synonyms?

1116

---

Is java required for oracle client?

971

---

What is sequence?

1055

---

How to create a stored program unit?

1193

---

What is oracle sid?

935

---

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'));

1673

---

What are the database administrators utilities available?

1007

---

How do I recompile a procedure in oracle?

947

---

What are the advantages of oracle 12c?

1158

---

What happens to the current transaction if the session is killed?

965

---

How would you change old and new values in an insert, delete and update triggers?

995

---

candidate key is subset of super key but not vice-verse explain

2056

---

How to connect ms access to oracle servers?

979

---