Re: Data conversion question: LONG to VARCHAR

From: dave mausner <dmausner_at_ameritech.>
Date: Wed, 08 Dec 1999 04:48:12 GMT
Message-ID: <UDl34.284$IN6.26480@nntp0.chicago.il.ameritech.net>

In article <384D9586.572BDB67_at_dallas.net>, Steve Batzer <sbatzer_at_dallas.net> wrote:
>next best thing is to convert the LONG to VARCHAR that I could search on.
>Or, is there a way to do a text search on a LONG attribute?

you can install the context option to do string searches in long data. if you have a license for it.

or you can export the table to a file, define a new table exactly alike except with the long column defined as varchar2(4000) or whatever, then import with ignore=yes option.

--
Dave Mausner, Senior Manager, Braun Consulting Inc., Chicago. Received on Tue Dec 07 1999 - 22:48:12 CST