Problem: text is shown without line break or chr(10);
suppose test
column_name (text)
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;