"Gary Avery" <Gary.P.Avery_at_Pharmacia.com> wrote in message
news:3ec1153e$0$9507$1406d58a_at_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.
>
LONGs are the most unusable data type ever been implemented in Oracle.
You can't do almost anything with them server-side. Migrate to CLOBs
asap. Oracle made every effort to make transition to LOBs smooth and
painless, so take advantage of it and forget about LONGs. To migrate in
pre-9.2, use TO_LOB() function along with CREATE TABLE AS SELECT
or INSERT INTO SELECT to migrate your LONGs, and in 9.2 you can
simply ALTER TABLE MODIFY (long_column {C|B}LOB [LOB storage]) to
migrate them in place.
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
Received on Tue May 13 2003 - 11:24:37 CDT
