Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the index id?
- 1 Answers
- 5644 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 the difference between a hot backup and a cold backup in oracle?
write a query that displays every Friday in a year with date?
What is a static data dictionary in oracle?
Is oracle an open source?
What is an oracle recycle bin?
What is bulk load in oracle?
How can I combine multiple rows into a comma-delimited list in oracle?
What is the usage of merge statement?
How would you go about verifying the network name that the local_listener is currently using?
can u call user defined functions in select statements
master table and child table performances and comparisons in Oracle ?
How to insert a record into a table?
Oracle General 
