in my application i creaated one interactive report and it has one column with multiple value(code) i need to display it with description whcih comes from another table.
tried with listagg and reg exp but no luck please advise. thanks very much in advance.
1:2:3: one single row with multiple program areas and related with one single id.
need to display with description
You could use function APEX_UTIL.STRING_TO_TABLE and loop values and construct string that return display values.
I have blog post about similar case
Function to convert SAP R&#x2F;3 material master maintenance status