Remove newline in PLSQL
- Rumesh Aponso (RMAX)

- Nov 5, 2024
- 1 min read
Updated: Nov 22, 2024
-- Way 1
SELECT
TRANSLATE('234
456
678', CHR(10) || CHR(13), '$') FROM DUAL;
-- Way 2
SELECT REPLACE(REPLACE('234
456
678', CHR(10), '$'), CHR(13), '%') FROM DUAL;Output:
Way 1

Way 2





Comments