Re: help : about long datatype

From: Rozi & George Goldberger <ghita_at_worldnet.att.net>
Date: Wed, 28 Mar 2001 02:40:32 GMT
Message-ID: <Aacw6.317$K%.243645@typhoon1.ba-dsg.net>

Your problem is that LONG can keep up to 2Gb and VARCHAR2 only 4000 chars.

Move only the first 4000 from LONG into VARCHAR2.

George

"C.K." <cklok2000_at_sinaman.com> wrote in message news:99p9o8$qv8$1_at_charm.magnus.acs.ohio-state.edu...
> i'm looking for solution for this asap
> i'm trying to make a trigger which will send some records to table B
> after/before insert to table A
> however, one of the field of table A must be a "LONG" datatype, while
that
> field in table B must be a "VARCHAR2" datatype for some reason.
> can you help me out of how to convert it or whatever way i can archieve
> that goal?
> i will appreicate it
>
>
>
Received on Tue Mar 27 2001 - 20:40:32 CST