Recent content by Patric

SELECT CASE WHEN listagg(DISTINCT t, ',') within GROUP(ORDER BY LENGTH(t) DESC) LIKE 'XXX%' THEN 'XXX' ELSE 'YY' END my_result FROM (SELECT 'XXX,YY,XXX,YY' AS t FROM dual); This gives the...