Re: Large amounts of text in tables

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 07 Jul 1999 22:49:53 +0800
Message-ID: <37836911.6CF3@yahoo.com>

pontiphex_at_my-deja.com wrote:
>
> I need to store large amounts of text in several columns of a table.
> Oracle8 has a limitation of only one 'LONG' per table. Whats the
> preffered method for storing large amounts of text in several columns of
> a table. Thanks.
>
> --Bryan
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

In O7 you have longs....(and they're junk)

In O8 you have BLOB, CLOB and BFILE...and they're great !

cf: dbms_lob
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Jul 07 1999 - 09:49:53 CDT