Problem: text is shown without line break or chr(10);
suppose test
column_name (text)
x
hello world hello world hello world hello world.
hello world.
sql i tried
select REPLACE(REPLACE( text, CHR(10) ), CHR(13) )
from dual
but it still give output in single line.
hello world hello world hello world hello world.hello world.
any solution is most welcome.
Solution that worked
select REPLACE(REPLACE(textn,chr(10) , '<br>'),chr(13),'')
INTO v_text
from dual;
Advertisement
Answer
Solution that worked
Sql
select REPLACE(REPLACE(textn,chr(10) , '<br>'),chr(13),'')
INTO v_text
from dual;