Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> CLOB and NVL
Is it possible to use NVL or DECODE with a CLOB in Oracle 8i?
For example,
select nvl(clob_column,'None') from table;
currently returns
ERROR at line 1:
ORA-00932: inconsistent datatypes
Thanks. Lisa Received on Mon Nov 05 2001 - 14:57:46 CST