Home Home    Forum    Blog    Feed your aggregator (RSS 2.0)

The Johnnynine Weblog - How to list this indexes on an oracle table
A weblog by Johnny Hughes
 
 Thursday, March 16, 2006

Here is the sql to view the indexes on an oracle table.  Just replace MYTABLENAME with yout table name:

select index_name, column_name, column_position from user_ind_columns
where table_name='MYTABLENAME' order by index_name, column_position

Thursday, March 16, 2006 11:35:49 PM (US Mountain Standard Time, UTC-07:00)  #    Comments [1]   Database | Oracle | Technical  | 
Monday, January 21, 2008 10:59:51 AM (US Mountain Standard Time, UTC-07:00)
Similar way, how can we get the listing of all sequences on selected table?
jaya
Name
E-mail
(will show your gravatar icon)
Home page

Comment (HTML not allowed)  

Enter the code shown (prevents robots):

Copyright © 2009 Johnny Hughes. All rights reserved.
DasBlog 'Portal' theme by Johnny Hughes.