Skip to content
Advertisement

how to split words in oracle

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;
User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement