long to varchar2

From: <brenogomes_at_my-deja.com>
Date: Wed, 22 Sep 1999 23:49:07 GMT
Message-ID: <7sbptf$3ni$1_at_nnrp1.deja.com>

[Quoted] I successfully performed migration from FoxPro 2.5 files to Oracle 8.0.4.0.0.

Fox memo fields were converted to long. All data are plain text, with 500 characters or less, due 254 fox limits.

In the new application it would better to use Varchar2(1000) instead Long. How could I read data from long and write to Varchar2 ?

[Quoted] I appreciate your suggestions.

Thanks in advance.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Sep 23 1999 - 01:49:07 CEST