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: marc parkinson <marcpark_at_starband.net>
Date: Fri, 18 Oct 2002 02:15:43 GMT
Message-ID: <F9Kr9.5059$h9.2386846817@twister1.starband.net>

Sorry, you can not substr a long.

"Phil Randolph" <Phil_Randolph_at_yahoo.com> wrote in message news:c5c8fdf1.0210171416.4e9fd6d_at_posting.google.com...
> Is there any way to extract the first 1000 characters from a field of
> type long using straight SQL ?
>
> Thanks,
> Phil
Received on Thu Oct 17 2002 - 21:15:43 CDT

This message: [ Message body ]
Next message: marc parkinson: "Re: Sequence without holes"
Previous message: Cynic: "mutating table issue"
In reply to: Phil Randolph: "Substring a long in SQL ?"
Next in thread: Jeff Smith: "Re: Substring a long in SQL ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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