Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the index id?
- 1 Answers
- 5559 Views
- Cognizant, TCS, I also Faced
- E-Mail Answers
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
| Is This Answer Correct ? | 0 Yes | 3 No |
What is Parallel Server ?
Explain the function of optimizer in oracle?
what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?
What are Schema Objects ?
How to convert times to characters in oracle?
Please explain oracle data types with examples?
What are the uses of linked server and explain it in detail?
what is the difference between oracle enterprise edition and oracle express edition?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
Can a formula column be obtained through a select statement ?
What is bind variable in oracle 11g?
What is oracle used for?
Oracle General 
