Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Help with function to verify if a index exists on table/columns

gui2Sep 27 2011 — edited Sep 27 2011
I need your help to create a function to verify if a index exists on table/columns.

I am trying to create, but I have problem with the indexed columns.

I can't to check the index name merely, because the index name may be different, but the columns can be equals.

And, I have to check the columns order too.

So, the function parameters will be the owner, table_name, columns and order columns?

Can some one help me to create this function to check that index exists?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 25 2011
Added on Sep 27 2011
7 comments
902 views