This is done in BV.
BV_ENUM_VALUES table, 3 column
TYPE_NAME Describe The name of enum variable.
INT_CODE DESCRIBE The int Number of a certin type. This Two Construct The Primary Key.
The Third Column Is Value Describe The Value of The Key.
SQL> SELECT * from bv_enum_values where type_name = 'mr_region_type' or type_name = 'mr_industry_type';
TYPE_NAME INT_CODE -------------------------- Value ------- -------------------------------------------------- ----------------------- MR_REGON_TYPE 0 Northeast
MR_REGON_TYPE 1 Northwest
MR_REGON_TYPE 2 North China
TYPE_NAME INT_CODE -------------------------- Value ------- -------------------------------------------------- ----------------------- MR_REGON_TYPE 3 East China
MR_REGON_TYPE 4 South China
MR_REGON_TYPE 5 China
TYPE_NAME INT_CODE -------------------------- Value ------- -------------------------------------------------- ----------------------- MR_REGON_TYPE 6 Southwest
MR_INDUSTRY_TYPE 0 Complete and Agent
MR_INDUSTRY_TYPE 1 Electricity Multi-Enterprise
TYPE_NAME INT_CODE -------------------------- Value ------- -------------------------------------------------- ----------------------- MR_INDUSTRY_TYPE 2 Power Construction, Installation Enterprise
MR_INDUSTRY_TYPE 3 Power Materials and Trade Enterprises
MR_INDUSTRY_TYPE 4 Power Material Manufacturing Enterprise
TYPE_NAME INT_CODE -------------------------- Value ------- -------------------------------------------------- ---------------------- MR_INDUSTRY_TYPE 5 Power Building Enterprise MR_Industry_Type 6 Power Generation
MR_INDUSTRY_TYPE 7 Power Supply and Power Management Enterprise
TYPE_NAME INT_CODE -------------------------- Value ------- -------------------------------------------------- ----------------------- MR_INDUSTRY_TYPE 8 Research, Design and Academy
MR_INDUSTRY_TYPE 9 Other
17 lines have been selected.
