RE: LONG data type

If you are using SQL*Plus you must SET LONG 32767 (or some large number)

Tom Harleman
11080 Willowmere Dr.
Indianapolis, IN 46280
317-844-2884 Home
317-843-9122 Home Office

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Rusnak, George A. II
Sent: Thursday, July 20, 2000 2: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).