Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Substring a long in SQL ?
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