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
5975 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

Can we use bind variables in oracle stored procedure?

983

How to insert a new row into a table in oracle?

1214

Explain about the analyze command in oracle?

1108

How to create a stored function in oracle?

1156

How to drop a stored procedure in oracle?

1102

What happens if the imported table already exists?

1076

Explain the use of rows option in exp command.

1146

How do I escape a reserved word in oracle?

1253

What is an oracle database?

1103

What are temporal data types in oracle?

1164

Explain parameter file in oracle.

1080

How can I introduce multiple conditions in like operator?

1047

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1746

How to define a sub function?

1198

How to get execution statistics reports on query statements?

1151