select index_name from user_indexes u where u.TABLE_NAME=upper('table

How do we know whether an index is created on a table ???

Question Posted / urmi

2 Answers
5868 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / urmi

select index_name from user_indexes u where u.TABLE_NAME=upper('table_name');

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2182

What is merge in oracle?

1034

How to do paging with oracle?

983

What is the difference between sharding and partitioning?

964

What is ordinary table in oracle?

1132

How to view the tablespaces in the current database?

961

How do I find my oracle client driver version?

1020

How to upsert (update or insert into a table)?

986

Explain an index segment?

1093

Explain the blob datatype?

1058

Explain parameter file in oracle.

1008

How to define and use table alias names in oracle?

921

Why do you create or replace procedures rather that drop and recreate.

990

What is tns service name?

1109

What are the system predefined user roles?

1026