i am trying to remove new line characters from LONG field how do i do that.
SQL does not allow us to select a LONG column via a subquery so you can select the long into a varchar2 from a PL/SQL block:
select long_column into string from some_table where condition;
now you have a varchar2 data type with the value of long.
Click Here to Expand Forum to Full Width