By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select length('(select count(unique(username)) from ABC.APPLICATIONLOG where
usertimestamp >= ''01-APR-21'') ')
from dual
| LENGTH('(SELECTCOUNT(UNIQUE(USERNAME))FROMABC.APPLICATIONLOGWHEREUSERTIMESTAMP>=''01-APR-21'')') |
|---|
| 97 |
select length('(select count(unique(username)) from ABC.APPLICATIONLOG where
usertimestamp >= ''01-APR-21'' AND usertimestamp <= ''01-MAY-21'') ')
from dual
| LENGTH('(SELECTCOUNT(UNIQUE(USERNAME))FROMABC.APPLICATIONLOGWHEREUSERTIMESTAMP>=''01-APR-21''ANDUSERTIMESTAMP<=''01-MAY-21'')') |
|---|
| 130 |