Re: Oracle Question!!

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Mon, 31 May 1999 20:12:33 GMT
Message-ID: <3758ecfe.12081312@newshost.us.oracle.com>

A copy of this was sent to Rishi Karan <rishi_at_activ-consult.de> (if that email address didn't require changing) On Mon, 31 May 1999 14:48:36 +0200, you wrote:

>Hello,
>could anyone please tell me if oracle´s got something equivalent to
>MSSQL Server´s "text" datatype to store large texts??? I´ve tried with
>CLOB but doesn´t sem to work!
>
>Thx in advance
>Rishi

What doesn't seem to work about it?

there are CLOBS -- the new preferred method for storing text upto 4gig.

There are longs -- the old, not recommened method for storing text upto 2gig.

See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'...

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon May 31 1999 - 15:12:33 CDT