Re: DECODE problem

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Sat, 02 Jun 2001 23:51:24 -0700
Message-ID: <3B19DE6B.AFF6A414@exesolutions.com>

Kevin McDaniel wrote:

> 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

I can't tell you whether it will work as I would never try it. The performance would be abysmal. I think you should re-evaluate why you are trying to create a view instead of just querying the underlying tables.

Daniel A. Morgan Received on Sun Jun 03 2001 - 01:51:24 CDT