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 test (OTHER1) AS
SELECT   2.95 FROM DUAL UNION ALL
SELECT   9.97 FROM DUAL UNION ALL
SELECT 119.93 FROM DUAL UNION ALL
SELECT   9.5  FROM DUAL;
4 rows affected

SELECT TO_CHAR(ROUND(other1, 1), 'FM990.0') || '%' AS other2
FROM   test

OTHER2

3.0%

10.0%

119.9%

9.5%

SELECT TO_CHAR(other1, 'FM990.0') || '%' AS other2
FROM   test

OTHER2

3.0%

10.0%

119.9%

9.5%

SELECT TO_CHAR(ROUND(other1, 1), 'FM990D0') || '%' AS other2
FROM   test

OTHER2

3.0%

10.0%

119.9%

9.5%

SELECT TO_CHAR(other1, 'FM990D0') || '%' AS other2
FROM   test

OTHER2

3.0%

10.0%

119.9%

9.5%