Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table job(WKT_values varchar(50))
insert into job values('POINT (-2.534981 52.14983)');
1 rows affected

insert into job values('POINT (555.534981 -1112.14983)');
1 rows affected

with cte as (select replace(replace(WKT_values, 'POINT (', ''), ')', '') as WKT_values
             from job)
select trim(regexp_substr(WKT_values, '[^ ]+', 1, levels.column_value))  
from cte, 
     table(cast(multiset(select level 
                         from dual connect by  level <= length (regexp_replace(cte.WKT_values, '[^ ]+'))  + 1) as sys.OdciNumberList)) levels


TRIM(REGEXP_SUBSTR(WKT_VALUES,'[^]+',1,LEVELS.COLUMN_VALUE))


-2.534981

52.14983

555.534981

-1112.14983


with cte as (select replace(replace(WKT_values, 'POINT (', ''), ')', '') as WKT_values
             from job)
select SUBSTR(WKT_values, 1, INSTR(WKT_values, ' ')-1) AS one_column,
       SUBSTR(WKT_values, INSTR(WKT_values, ' ')+1) AS another_column
from cte


ONE_COLUMN
ANOTHER_COLUMN


-2.534981
52.14983

555.534981
-1112.14983