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 are set operators?
What are the uses of Rollback Segment ?
What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
hai, when to use char and varchar2....?
Difference between pre-select and pre-query
what is the syntax of ALTER command?
What is Oracle table?
How to build data dictionary view an new database?
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ================ 1 NULL 2 NULL 3 4 NULL 5 6 7 NULL NULL O/P C = 2 4 6
How can we Update a table with out using UPDATE command?
Explain the use of log option in exp command.
how to join query for one source type is oracle another source type is sql server ?