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 -> How to Search for a string in the TEXT column of dba_views

How to Search for a string in the TEXT column of dba_views

From: Mario King <hliji_at_yahoo.com>
Date: 17 Sep 2004 13:15:15 -0700
Message-ID: <a3f90977.0409171215.5c9c9460@posting.google.com> 





Hi,



I tried to search a string from dba_views and got ORA-00932
inconsistent datatypes for text (long):



select view_name from dba_views


where TEXT like 'MY STRING'



How to do it correctly?



MK
Received on Fri Sep 17 2004 - 15:15:15 CDT












Original text of this message













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