Important Tables

Table Name : ALL_TAB_COLUMNS
This table is used to get the column details of the given table

select column_name,data_type,data_length,nullable from ALL_TAB_COLUMNS where TABLE_NAME='OE_ORDER_HEADERS_ALL'


Table Name : ALL_IND_COLUMNS
This table is used to fetch the indexes and the columns to which the index was applied.

select index_name,column_name from all_ind_columns where TABLE_NAME='OE_ORDER_HEADERS_ALL'



.