Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the index id?
- 1 Answers
- 5573 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 |
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
what's query optimization and without use of IN AND Exist can we get another way data from query
Write a simple Store procedure and pass parameter to it ?
How to get a list of all tables in the database?
How to write a query with an inner join in oracle?
What is the Difference between 1) ER MODEL and Relational Model 2) Dense Index and Sparse Index
How to use "in out" parameter properly?
How to define an oracle sub procedure?
What is the difference between RBBMS & DBMS?
How to restrict the duplicate records in table valuesets
what is the difference between primary key & foreign key?
57 Answers CTS, Infosys, La Multi, Sparsh, Wipro,
How to run queries on external tables?
Oracle General 
