Re: show indexes

Envoy wrote:

> Hi,
>
> how can I get meta-data information in Qracle9i?
> Especialy I'm interrested in retrieving already created indices on my tables.
>
> Thanks a lot in advance.
> Andreas

Query:

USER_INDEXES
USER_IND_COLUMNS For more:

SELECT view_name
FROM all_views
WHERE view_name LIKE '%IND%';

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)