Xref: alice comp.databases.oracle.server:56420 Path: alice!news-feed.fnsi.net!netnews.com!newspeer.monmouth.com!diablo.theplanet.net!news.theplanet.net!newspost.theplanet.net!not-for-mail From: Connor McDonald Newsgroups: comp.databases.oracle.server Subject: Re: Large amounts of text in tables Date: Wed, 07 Jul 1999 22:49:53 +0800 Organization: Customer of Planet Online Lines: 24 Message-ID: <37836911.6CF3@yahoo.com> References: <7lvpb7$eh4$1@nnrp1.deja.com> Reply-To: connor_mcdonald@yahoo.com Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: news5.svr.pol.co.uk 931383971 14870 62.136.196.161 (7 Jul 1999 21:46:11 GMT) NNTP-Posting-Date: 7 Jul 1999 21:46:11 GMT X-Complaints-To: abuse@theplanet.net X-Mailer: Mozilla 3.01 (Win95; I) To: pontiphex@my-deja.com pontiphex@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@yahoo.com "Some days you're the pigeon, and some days you're the statue."