Re: long datatype

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 27 Nov 2002 23:08:46 +0100
Message-ID: <oggauuo8gk6tg9mjlit3v277q55jj3ekre@4ax.com>

On Wed, 27 Nov 2002 19:18:51 GMT, meinhfxGARBAGE_at_hotmail.com (tony) wrote:

>I have a table that has a long datatype for one of the columns. I
>believe this was done so that there could be carriage returns stored
>in the column. Anyway, I would like to find all occurrences in this
>long field of "character string one" ane update the table with
>"character string two". Of course I can't use builtin functions on
>the long or even use it in the where clause. Is this possible in sql?
>
>
>thanks

No it isn't, unless you are using Oracle Intermedia (with the contains operator).
You would better replace the long by a CLOB, the dbms_lob.instr function on the CLOB will do exactly want you want, and longs are going to disappear in the next major version from 9i

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Nov 27 2002 - 16:08:46 CST