Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
with your_table (f_date) as (
  select date '2022-01-01' from dual union all
  select date '2022-07-04' from dual union all
  select date '2022-12-31' from dual
)
select to_char(f_date, 'DDMONYYYY', 'nls_date_language=english') as date9
from your_table


DATE9


01JAN2022

04JUL2022

31DEC2022


with your_table (f_date) as (
  select 20220101 from dual union all
  select 20220704 from dual union all
  select 20221231 from dual
)
select to_char(to_date(f_date, 'YYYYMMDD'), 'DDMONYYYY', 'nls_date_language=english') as date9
from your_table


DATE9


01JAN2022

04JUL2022

31DEC2022


with your_table (f_date) as (
  select 20220101 from dual union all
  select 20220704 from dual union all
  select 20221231 from dual
)
select to_char(to_date(to_char(f_date), 'YYYYMMDD'), 'DDMONYYYY', 'nls_date_language=english') as date9
from your_table


DATE9


01JAN2022

04JUL2022

31DEC2022