Re: index in SQL*Plus

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Thu, 07 Nov 2002 22:30:32 +0100
Message-ID: <spmlsug3u41vgqj2ll6rpn7dqrbpv89pl2_at_4ax.com>


On Thu, 07 Nov 2002 17:14:04 GMT, chess hazlett <puneyrf_f_unmyrgg_at_enlgurba.pbz> wrote:

>Anyone know how to find the index of a table in SQL*Plus (or, for that
>matter, PL/SQL would work, too) ?
>
>Thanks.

select index_name
from user_indexes
where table_name = '<your table>'

Please try to
select * from dict where table_name like '%IND%' before posting

Hth

[Quoted] Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Nov 07 2002 - 22:30:32 CET

Original text of this message