Create A profile option with List of Values form Table in Oracle

Application developer -- profile

Create the profile as given below

Name : XX_CUST_PRF
Application: XXCUST Custom
User profile name:  XX_Custom _Name
Description: -------

SQL validation used for the profile Option's List of values

SQL="SELECT Column_name \"Negotiation Styles\", column_id
INTO :VISIBLE_OPTION_VALUE, :PROFILE_OPTION_VALUE
FROM Table_name
WHERE 1 = 1"
COLUMN="\"Negotiation Styles\"(*)"


Ex:
 SQL="SELECT style_name \"Negotiation Styles\", style_id
INTO :VISIBLE_OPTION_VALUE, :PROFILE_OPTION_VALUE
FROM pon_negotiation_styles_vl
WHERE 1 = 1"
COLUMN="\"Negotiation Styles\"(*)"