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: How can i extract (substr(field,1,200) ) a substring on a long or long raw field

Re: How can i extract (substr(field,1,200) ) a substring on a long or long raw field

From: Neil Chandler <oracle_at_tchp2.tcamuk.stratus.com>
Date: 21 Apr 1998 10:50:32 GMT
Message-ID: <slrn6joue5.jcc.oracle@tchp2.tcamuk.stratus.com> 





In article <353b74d0.0_at_news.total.net>, "Ronald Berube" wrote:



Ron,



You can't. You are not allowed to put ANY functions against a LONG field.
You can't query a LONG field either.


All you can really do with them is INSERT and SELECT.



regs



Neil Chandler, LONG hater.





BCan someone, can indicate me how to extract a substring from  a long or long


>raw field.


>


>Every time i try to extract extract    substr(field,1,200) the oracle server


>return me


>


>type of data not compatible


>


>


>Thank's for any help


>


>Ronald


>


>berube.ronald_at_tourisme.gouv.qc.ca


>


>



Received on Tue Apr 21 1998 - 05:50:32 CDT












Original text of this message













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