Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Easy question - how to find table indices

Re: Easy question - how to find table indices

From: Michel Cadot <micadot_at_netcourrier.com>
Date: 2000/06/05
Message-ID: <8hgii1$6c1$1@s2.feed.news.oleane.net>#1/1 






You can try:



select table_name, index_name from user_indexes
order by 1, 2


/


--
Have a nice day
Michel


<rainbow24k_at_my-deja.com> a écrit dans le message : 8hgfc5$3j9$1_at_nnrp1.deja.com...


> I would like to know in SQL Plus 3.3 how I can find the indices for a

> table.

>

> Thank you in advance.  I couldn't find my answer by searching nor in

> the Oracle book I have.

>

> Suzan

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.



Received on Mon Jun 05 2000 - 00:00:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US