Wednesday, December 22, 2010

Find Index

column table_name format a30
column index_name format a30
column column_name format a20
break on table_name,index_name
set lines 132
select table_name,index_name,column_name from dba_ind_columns where index_owner='&OWNER' and table_name = '&tab_name' order by 1,2,column_position;

No comments:

Post a Comment