Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the index id?
- 1 Answers
- 5557 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 |
Describe the types of sub query?
What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
What is integrity and what is constraint??Explain with example
What is where clause in oracle?
what is Table ?
how will I find the first 5 highest salaried employees in each dept in oracle.
Explain oracle insert into command?
what is the syntax of INSERT command?
What is primefaces used for?
Give syntax for SQL and ORACLE joins.
What are the set operators union, union all, minus & intersect meant to do?
Oracle General 
