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 -> SEARCHING FOR TEXT PATTERN IN "LONG" COLUMN

SEARCHING FOR TEXT PATTERN IN "LONG" COLUMN

From: SAL <2_at_2.com>
Date: Tue, 2 Sep 2003 14:49:16 -0400
Message-ID: <bj2oin$n8611@kcweb01.netnews.att.com> 





All,


I would like to do something like:


select view_name from user_views where text like 'CURRENT%';
Obviously I can not do it because TEXT column in user_views is LONG. Is
there any way around it? I have looked at many dbms stored procedures, but
can not find one that will do this.


Any help will be appreciated.



Sal
Received on Tue Sep 02 2003 - 13:49:16 CDT












Original text of this message













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