select
substr(index_name,1,30) Index_nm,
substr(table_name,1,9) Table_nm,
substr(column_name,1,15) Column_nm,column_position
from all_ind_columns where table_name =upper('&table')
order by index_name,column_position
substr(index_name,1,30) Index_nm,
substr(table_name,1,9) Table_nm,
substr(column_name,1,15) Column_nm,column_position
from all_ind_columns where table_name =upper('&table')
order by index_name,column_position
No comments:
Post a Comment