Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

can any body explain me this query? select 'alter index '||index_name||' monitoring usage' as inde

kbdevelopersAug 19 2013 — edited Aug 19 2013

Initially i've a put an index of emp table in monitoring state..

later i've got this query

select 'alter index '||index_name||' monitoring usage' as index_monitor from user_indexes where index_name='EMP';

can any body explain me what is the meaning of this query...

and how do that query in the strings of projection area works....

i'm totally confused

thank you in advance.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 16 2013
Added on Aug 19 2013
6 comments
284 views