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 -> Re: using a clob in a where clause

Re: using a clob in a where clause

From: <yong321_at_yahoo.com>
Date: 27 Apr 2005 13:30:50 -0700
Message-ID: <1114633850.028185.106820@o13g2000cwo.googlegroups.com>

Try
WHERE DBMS_LOB.SUBSTR(a.REPORT_EXPRESSION_TX) = ' '

Yong Huang Received on Wed Apr 27 2005 - 15:30:50 CDT

This message: [ Message body ]
Next message: Sybrand Bakker: "Re: index creation fails because temp tablespace is too small"
Previous message: Dutch_alien: "Re: index creation fails because temp tablespace is too small"
In reply to: Oxnard: "using a clob in a where clause"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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