Re: How do I convert LONG to VARCHAR2?
From: <jffaure_at_hotmail.com>
Date: Fri, 04 Feb 2000 16:41:16 GMT
Message-ID: <87evfb$d2r$1_at_nnrp1.deja.com>
Jean-Francois FAURE
Email:jffaure_at_hotmail.com
TOULOUSE - FRANCE
Date: Fri, 04 Feb 2000 16:41:16 GMT
Message-ID: <87evfb$d2r$1_at_nnrp1.deja.com>
Hello,
In PL/SQL in a stored procedure, you can assign a LONG to a VARCHAR2 with a length < 32000 characters.
Jean-Francois FAURE
Email:jffaure_at_hotmail.com
TOULOUSE - FRANCE
WWW : http://paid2surf.ifrance.com/paid2surf/ http://perso.libertysurf.fr/jffaure/sommaire.html ________________________________________________________________________
In article <389A6E4E.562D2C2_at_home.com>,
Al Salvador <alsalvador_at_home.com> wrote:
>
> I have a table with a field defined as LONG. It has regular text in it
> (none greater than 2000 characters). I want to assign it to a VARCHAR2
> variable in PL/SQL so I can save it as a VARCHAR2 field in another
> table. If I can't do this in PL/SQL, can I use some sort of
> export/import to get a LONG field into a VARCHAR2 field? Anyone have
> any ideas? Thanks.
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Feb 04 2000 - 17:41:16 CET