ORACLE

SELECT  REGEXP_SUBSTR(T.CNT, '[^^]+', 1, 1) AS CNT_T
,       REGEXP_SUBSTR(T.CNT, '[^^]+', 1, 2) AS CNT_S
,       REGEXP_SUBSTR(T.CNT, '[^^]+', 1, 3) AS CNT_B
,       REGEXP_SUBSTR(T.CNT, '[^^]+', 1, 4) AS CNT_N
FROM (SELECT '1481^333^1146^2' AS CNT
      FROM DUAL) T
;

POSTGRESQL

SELECT  SPLIT_PART(T.CNT, '^', 1)    AS CNT_T
,       SPLIT_PART(T.CNT, '^', 2)    AS CNT_S
,       SPLIT_PART(T.CNT, '^', 3)    AS CNT_B
,       SPLIT_PART(T.CNT, '^', 4)    AS CNT_N
FROM (SELECT '1481^333^1146^2' AS CNT) T
;

결과는 같다.