By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ALTER SESSION SET NLS_NUMERIC_CHARACTERS = ',.'
WITH DST__D_DATA(per_growth) AS
(
SELECT 134.56 FROM dual
)
SELECT 'dst.'||.01*TO_NUMBER( per_growth,
'FM9G999G999G999G999G990D99999999999',
'NLS_NUMERIC_CHARACTERS = '',.'' ') As result
FROM dst__d_data;
| RESULT |
|---|
| dst.1,3456 |