Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> LONG to varchar2

LONG to varchar2

From: Gary Avery <Gary.P.Avery_at_Pharmacia.com>
Date: Tue, 13 May 2003 16:54:38 +0100
Message-ID: <3ec1153e$0$9507$1406d58a@newsread.pharmacia.com>


HELP!! I'm having alot of difficulty in finding out how to convert a long datatype (which only contains text) to a varchar2. If this is too difficult can anyone suggest a method of removing any chr(10) and chr(13)'s from a long datatype.

Any help appreciated.

Thanks

Gary Received on Tue May 13 2003 - 10:54:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US