This content has been marked as final. Show 3 replies
you can use regular expression.
Actually I could not test completely your query as I don't have STRAGG in my DB. There are several new alternatives to STRAGG. On 11g you can use LISTAGG.
Anyway assuming that using STRAGG after the comma you have one space you can do in this way:
If STRAGG don't put a space after the comma then remove the space after the comma in the regular expression pattern:
select pfv.name, pfv.function_types from person_function_view pfv where regexp_like(pfv.function_ids ,'(^|, )1(,|$)');
where regexp_like(pfv.function_ids ,'(^|,)1(,|$)');