i am trying to remove new line characters from LONG field how do i do that.
Printable View
i am trying to remove new line characters from LONG field how do i do that.
Hi,
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:
declare
string varchar2(100);
begin
select long_column into string from some_table where condition;
end;
now you have a varchar2 data type with the value of long.