how to get the index id?

Question Posted / dibya jiban

1 Answers
5649 Views
Cognizant, TCS, I also Faced
E-Mail Answers

how to get the index id?..

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

Post New Answer

More Oracle General Interview Questions

Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?

1 Answers

What is a cursor variable?

0 Answers

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

0 Answers

Is oracle an open source?

0 Answers

What are inner join and outer join?

3 Answers

What are the different types of trigger and explain its various uses and functions?

0 Answers

can you explain performance tunning in oracle(sql,PL/SQL)

2 Answers

what is integrity constrains?

3 Answers

What do you mean by cdb and pdb in oracle 12c?

0 Answers

How to define an oracle cursor variable?

0 Answers

What is oracle sid?

0 Answers

SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me

6 Answers TCS,

For more Oracle General Interview Questions Click Here