DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: how to convert long to varchar2 for manipulation

  1. #1
    Join Date
    Mar 2001
    Posts
    61
    i am trying to remove new line characters from LONG field how do i do that.

  2. #2
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268
    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
  •  


Click Here to Expand Forum to Full Width