Re: 10g field varchar size

DA Morgan schreef:

> Frank van Bortel wrote:
> > DA Morgan schreef:
> >
> > But you cannot use a clob in a where clause
>
> CREATE TABLE demo (
> clobcol CLOB);
>
> INSERT INTO demo (clobcol) VALUES ('This is a test');
> INSERT INTO demo (clobcol) VALUES ('This is not a test');
> COMMIT;
>
> desc demo
>
> SELECT * FROM demo;
>
> SELECT *
> FROM demo
> WHERE dbms_lob.substr(clobcol, 32767, 1) LIKE '%not%';
>

Correct - but not directly; like
where <clob_col> like ...
You have to use a function Received on Mon Aug 14 2006 - 04:12:14 CDT