-- 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;
"All truths are easy to understand once they are discovered; the point is to discover them." - Galileo Galilei (rmaxonenote is a place for Oracle PL/SQL, C# and IFS related solutions, code snippets, and etc...)
Search This Blog
Subscribe to:
Post Comments (Atom)
Read file content from an Oracle Directory in PL/SQL/ in IFS
Read single file DECLARE file_handle_ UTL_FILE.FILE_TYPE; directory_name_ CONSTANT all_directories.directory_name%TYPE := ...
No comments:
Post a Comment