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: Substring a long in SQL ?

Re: Substring a long in SQL ?

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Thu, 17 Oct 2002 23:18:54 GMT
Message-ID: <3DAF4553.99127F09@exesolutions.com>


Phil Randolph wrote:

> Is there any way to extract the first 1000 characters from a field of
> type long using straight SQL ?
>
> Thanks,
> Phil

No.

But the good news is that Oracle is dropping LONG with the next release so you might as well drop them too and move your work to a CLOB where you can substring using the DBMS_LOB package.

Daniel Morgan Received on Thu Oct 17 2002 - 18:18:54 CDT

Original text of this message

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