Re: How can I limit the size of field in this SQL query?

"john" <uu_gg_at_hotmail.com> wrote in message news:a82b1436.0204241119.cbfe816_at_posting.google.com...

> Hi,
> I have this query I use to exract data from Oracle8i DB, and one
> field's "ref_text" Datatype is "Long", when I do the query I want to
> limit this data to 2000 Char, how can I do that? I tried to use
> substr() and max(), length(), but no luck so far. Could you please
> show me how to do this, thanks.
>
> John

<<<---snip--->>>

Hi,

have a look at Tom Kytes site

http://asktom.oracle.com/pls/ask/f?p=4950:8:728944::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:55212348054,%7Blong%7D

(remove CR)

or generally serarch for LONG on the site ...

String functions are not usable with long datatype ins sql but in PL/SQL ...

HtH
Thomas (no, not Kyte :-) )

-- 
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG