Re: LONG data type

Al,

You need to issue:

SET LONG 100000 before SELECTING from the LONG data type. This will show the first 100,000 bytes. If you need more set the number larger.

Best regards,

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 370+ Oracle tips, visit:                         <->
<->                                                      <->
<->             www.arikaplan.com                        <->
<->                                                      <->
<->             email: akaplan_at_interaccess.com           <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

On Thu, 20 Jul 2000, Rusnak, George A. II wrote:

>
> How do I 'SELECT' from a LONG data type? When I do a 'SELECT', it seems to
> return just part of the view and nothing from the 'FROM' or 'WHERE' clauses.
>
> TIA
>
> Al Rusnak
>
> --
> Author: Rusnak, George A. II
> INET: rusnakg_at_SDCL.LEE.ARMY.MIL
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Thu Jul 20 2000 - 14:28:46 CDT