Re: Query against LONG type?

From: TimKArnold <timkarnold_at_aol.com>
Date: 03 Jul 1999 00:06:39 GMT
Message-ID: <19990702200639.27922.00006764@ng-fd1.aol.com>

Oracle Context Option (OCO)
in Oracle 8i it is called InterMedia Text. It takes a little work, but very powerful.

Good luck,
Tim

>Scenario: I have a problem ticket database with comment fields. Since
>4000 characters was too short, I couldn't use a VARCHAR2 for the comment
>field, and went with a LONG. I'd like to be able to do searches against
>that field, but Oracle doesn't permit searching against LONG field types.
>Are there any good workarounds for this?
>
>-Rick
>
>--
>+--------------------------------------------------------------------------+
>| Rick Osterberg osterber_at_fas.harvard.edu |
>+--------------------------------------------------------------------------+
></PRE></HTML>
Received on Fri Jul 02 1999 - 19:06:39 CDT