Oracle 21c

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 table_name (column_name) AS
  SELECT 'abc xyz-1234' FROM DUAL;
1 rows affected

SELECT SUBSTR(column_name, spos + 1, hpos - spos - 1)
       || ','
       || SUBSTR(column_name, 1, spos - 1) AS formatted_column_name
FROM   (
  SELECT column_name,
         INSTR(column_name, ' ') AS spos,
         INSTR(column_name, '-') AS hpos
  FROM   table_name
);


FORMATTED_COLUMN_NAME


xyz,abc


SELECT REGEXP_REPLACE(column_name, '^(.*?) (.*?)-.*$', '\2,\1')
         AS formatted_column_name
FROM   table_name


FORMATTED_COLUMN_NAME


xyz,abc