RE: LONG data type

From: Jain, Akshay <Akshay.Jain_at_cit.com>
Date: Thu, 20 Jul 2000 16:46:51 -0400
Message-Id: <10564.112584@fatcity.com>

In SQLPlus, try
SET LONG 4000 This will stop the truncating of the long field that you are experiencing.

Akshay Jain

Newcourt-CIT
Tel. (416) 507-5385
mailto:Akshay.Jain_at_cit.com

-----Original Message-----
From: Rusnak, George A. II [mailto:rusnakg_at_SDCL.LEE.ARMY.MIL] Sent: Thursday, July 20, 2000 3:14 PM
To: Multiple recipients of list ORACLE-L Subject: LONG data type

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 - 15:46:51 CDT