By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
WITH multivalue (ID, CURR_ASSET_TYPE, OPEN_BALANCE, DEBIT_MVMT, CREDIT_MVMT) AS(
VALUES
('0023216531', 'CREDITýCREDIT', '315246ý', 'ý-315246', 'ý315246'),
('0023216540', 'CREDITý50000ý50000ýCREDITý50000', '2173118.69ý432ýýý', 'ýýýý-461.69', 'ýý14.85ý461.69ý14.84'),
('0023216558', 'DEBITýDEBIT', '-5000ý', 'ý', 'ý5000'),
('0023216477', 'CREDITý50000ý50000ýCREDITý50000', '121667.58ý25.14ýýý', 'ýýýý-26.8', 'ýý0.83ý26.8ý0.83')
)
SELECT *
FROM multivalue
| ID | CURR_ASSET_TYPE | OPEN_BALANCE | DEBIT_MVMT | CREDIT_MVMT |
|---|---|---|---|---|
| 0023216531 | CREDITýCREDIT | 315246ý | ý-315246 | ý315246 |
| 0023216540 | CREDITý50000ý50000ýCREDITý50000 | 2173118.69ý432ýýý | ýýýý-461.69 | ýý14.85ý461.69ý14.84 |
| 0023216558 | DEBITýDEBIT | -5000ý | ý | ý5000 |
| 0023216477 | CREDITý50000ý50000ýCREDITý50000 | 121667.58ý25.14ýýý | ýýýý-26.8 | ýý0.83ý26.8ý0.83 |