Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> CLOB and NVL

CLOB and NVL

From: Lisa T <tennysonll_at_navair.navy.mil>
Date: 5 Nov 2001 12:57:46 -0800
Message-ID: <9669d989.0111051257.219a726@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US