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 |
How to create an oracle database?
What is user managed backup in Oracle?
What is execute immediate in oracle?
What is the usage of save points in oracle database?
how to create a new database in oracle?
What are virtual columns?
1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.
How to delete a column in an existing table in oracle?
can u plz provide me oca sql dumps please i need them
what are the diffeenes between oracle 9i,oracle 10g
What are the built-in functions used for sending Parameters to forms ?
How to use regular expression in pattern match conditions in oracle?