I have a problem with the newlines characters stored in the database fields.
I need to print out all the database values into a text file separated by pipelines between columns. (e.g. col1|col2|col3|col4|col5). However, for column 4 which is a columm that stores user remarks always contains newline characters. Thus when I print the values out into the text file there will always a break in rows.
This will pose a problem here when I wanna to load the text file of values into another application database using SQLloader.
Is there anyway to replace newline characters (as well as tab characters) with a space character ?
(P.S: My database is Oracle 9i. I use sqlplus spool function to print values into the spool file.)
THANKS in advance to whoever tat can provide me help.