Multi Line Description to Single line in Oracle
You want to replace line breaks with blanks regexp_replace(col, '[[:space:]]+' , ' ' ) regexp_replace(col, '[[:cntrl:]]+' , ' ' ) Original Output ------------------- ID TEXT -------------------------------------- 1 test message 123456 Using the above function we will get ID TEXT -------------------------------------- 1 test message 123456