Re: want to know the reason for varchar2(4000) limit

From: Tanel Poder <change_to_my_first_name_at_integrid.info>
Date: Sat, 25 Oct 2003 14:15:44 +0300
Message-ID: <3f9a5b61$1_1@news.estpak.ee>

> Can they be used freely now in query predicates?

If this was a question, then no, not quite freely. But using functions (and FBIs) it's possible:

SQL> create table t (a varchar2(4000), b clob); Table created.
SQL> insert into t values ('XXX', 'XXX'); 1 row created.
SQL> insert into t values ('XXX', 'YYY'); 1 row created.
SQL> select * From t where a=b;
select * From t where a=b

                        *

ERROR at line 1:
ORA-00932: inconsistent datatypes: expected - got CLOB

SQL> select * From t where a=to_char(b);

A B
---------- ----------
XXX XXX Tanel. Received on Sat Oct 25 2003 - 06:15:44 CDT