Re: Why is VARCHAR2(4000) bad ?
From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 25 Jan 2008 20:59:35 -0800
Message-ID: <1201323554.357634@bubbleator.drizzle.com>
> CLOBs are SQL Standard. The DBMS_LOB package (or whatever it is called)
> is not, of course.
>
> Cheers
> Serge
Date: Fri, 25 Jan 2008 20:59:35 -0800
Message-ID: <1201323554.357634@bubbleator.drizzle.com>
Serge Rielau wrote:
> Walt wrote:
>> Harel wrote: >>> Questions: >>> - Since we dont know in advance the size we will really need in the >>> future, is there a VARCHAR2(*) ? >> >> Sort of. It's called a CLOB, and is the better way to deal with >> arbitrarily long strings. Dealing with CLOBs can be a little tricky >> since they're proprietary to Oracle and not standard SQL (i.e. you >> can't expect to use them with ODBC etc.) I wouldn't use a CLOB for >> this purpose.
> CLOBs are SQL Standard. The DBMS_LOB package (or whatever it is called)
> is not, of course.
>
> Cheers
> Serge
How long before you build the equivalent of DBMS_LOB into DB2 Serge? I'm betting before the decade is over. That is if you don't want to be reporting to Mark.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Fri Jan 25 2008 - 22:59:35 CST