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