how to get the index id?
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 sequence?
What is instant client oracle?
What is truncate oracle?
What is a Temporary Segment ?
What is the use of aggregate functions in oracle?
Describe Referential Integrity ?
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
What different of iner joint & outer joint with example
How to install oracle odbc drivers?
What is an Integrity Constrains ?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
What are the components of logical database structure in oracle database?