Re: long datatype

Thanks again. I've done a littl eresearch ono dbms_lob and it looks like what I want. Can you suggest a technique to replace the long with clob?

tony

On Wed, 27 Nov 2002 23:08:46 +0100, Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote:

>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 Thu Nov 28 2002 - 13:28:42 CST