DECODE problem

From: Kevin McDaniel <kmcdaniel96_at_home.com>
Date: Sat, 02 Jun 2001 21:12:58 GMT
Message-ID: <uFcS6.14807$mG4.8092168@news1.mntp1.il.home.com>

I have a CREATE VIEW statement that contains a DECODE statement. Here's the DECODE statement:

DECODE(finding, NULL, finding_text, finding) result_type

The problem is, finding is VARCHAR2 and finding_text is CLOB. I've been reading up on DBMS_LOB to determine if I can use this package here to complete the DECODE, but I can't find a definitive answer. Can anyone tell me if this package will work with what I'm trying to do? Thanks in advance.

Kevin Received on Sat Jun 02 2001 - 16:12:58 CDT