By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE tablename (Token varchar2(1));
INSERT ALL
INTO tablename (Token) VALUES ('A')
INTO tablename (Token) VALUES ('B')
INTO tablename (Token) VALUES ('B')
INTO tablename (Token) VALUES ('C')
INTO tablename (Token) VALUES ('A')
INTO tablename (Token) VALUES ('X')
SELECT * FROM dual;
6 rows affected
WITH cte AS (
SELECT LISTAGG(Token, ',') WITHIN GROUP (ORDER BY Token) Tokens
FROM (SELECT DISTINCT Token FROM tablename) t
)
SELECT CASE Tokens
WHEN 'A,B' THEN 'Condition1'
WHEN 'A,B,C' THEN 'Condition2'
ELSE 'Nothing'
END condition_met
FROM cte
| CONDITION_MET |
|---|
| Nothing |