By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
CREATE TABLE DOCUMENT_ATTRIBUTE (value) AS
SELECT '*' FROM DUAL UNION ALL
SELECT ' * ' FROM DUAL UNION ALL
SELECT 'NO' FROM DUAL;
3 rows affected
select documentat2_.*
, case
when (REGEXP_LIKE(documentat2_.VALUE,'^(\\*)$'))
then 1
else 0
END AS x
from -- ...
DOCUMENT_ATTRIBUTE documentat2_
where -- ...
documentat2_.VALUE='*'
| VALUE | X |
|---|---|
| * | 0 |
select documentat2_.*
, case
when (REGEXP_LIKE(documentat2_.VALUE,'^\*$'))
then 1
else 0
END AS x
from -- ...
DOCUMENT_ATTRIBUTE documentat2_
where -- ...
documentat2_.VALUE='*'
| VALUE | X |
|---|---|
| * | 1 |