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 -> Would like to do .... LIKE '%fred%' on LONG column

Would like to do .... LIKE '%fred%' on LONG column

From: Paul Smith <syd_at_compuserve.comz>
Date: Wed, 21 Oct 1998 08:50:55 GMT
Message-ID: <362d9fbd.1269164@news.eur.sprynet.com> 





I would like to add a where clause to a select on a long column, but I always
get an oracle error stating that there are inconconsistent datatypes
(ORA-00932). I can't even do a TO_CHAR() on the column. This seems like a big
oversight to me - is there *any* way to do what I want to do?




--


Paul Smith


Technical Manager, SDR Systems Ltd


Please change Compuserve.comz to Compuserve.com to respond via Email
Received on Wed Oct 21 1998 - 03:50:55 CDT












Original text of this message













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