Re: Why not varchar2 = 2000?

From: Kim Ng <kimmng_at_pebbles.uswnvg.com>
Date: 26 Jan 1995 16:59:01 GMT
Message-ID: <3g8kcl$ih5_at_fred.uswnvg.com>

By the way, if you use large fields (such as VARCHAR2(2000)), make sure that your database block is big enough to accomodate it and the rest of the columns in your "select" statement that forces ORACLE to do sorting (such as "group by", "distinct" and "order by"). Otherwise, you will get a very vague error message and your "select" will DIE !

For example, if your database block is 2048 bytes and you are doing the following SQL:
  select distinct a, b from test;
where a is 49 bytes and b is 2000 bytes.

When you try to run it, ORACLE will burp and give you strange message.

Have fun

---

 (Whatever I say and own are mine, mine and only mine! So, don't you dare   claim they are yours!)
 Kim Ng
 Paradigm Computer Consulting, Inc.
 20611 E Bothell-Everett Hwy SE, Suite 280  Bothell, WA 98012
 U.S.A. Received on Thu Jan 26 1995 - 17:59:01 CET