Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: s.o.s. help

Re: s.o.s. help

From: Feng Xiong <fengx_at_wolfram.com>
Date: Mon, 01 Mar 1999 12:44:00 -0600
Message-ID: <36DADFF0.600A70CA@wolfram.com>

Francoise Bouffard wrote:

> I want to know if it's possible to do a 'substr' on a field define as
> 'long' ??? how??? if it's possible.
> Françoise.

No you can't. You can only select, insert, and update LONG columns. Anything conditional such as where, group by, order by, or any sql functions like substr can't be applied to LONG datatypes.

Feng Received on Mon Mar 01 1999 - 12:44:00 CST

Original text of this message

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