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'



.

Distinct Values in Value Set

To get distinct values in a valueset (without creating a view), the following steps can be followed

In the place of table name use the following
(select distinct column_name from table_name) a

where 'a' is the alias nameIn the value field give
a.column_name