How to convert &variable. into string
Guru's
I am trying to get Region_name using sql query and apex view. Purpose of this query is to create worksheets in workbook.(if my page have 3 region then workbook have 3 worksheets and each worksheet name will be region name) if my region name is like "Work assigned to &APP_USER_NAME." then how can I convert it to "Work assigned to Vipul Patel" (considering in my current session &APP_USER_NAME is populated with "Vipul Patel")
Is there any apex function which I can used? like select apex.convert_to_string(region_name) from dual........