-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|