Home -> Usenet -> comp.databases.oracle -> Question About Viewing Portion of LONG Value in SQL*Plus

Question About Viewing Portion of LONG Value in SQL*Plus

From: scott.d.brenner <sbrenner_at_cbnewsb.cb.att.com>
Date: 16 Jul 93 13:26:10 GMT
Message-ID: <CA9Enn.3By_at_cbfsb.cb.att.com> 






I think this has been asked and answered before, but the solution has
escaped me.  I'm looking for a way to view the first 50 or so characters
of a LONG datatype using SQL*Plus.  (I know they're not really "characters,"
but you know what I mean!)  I can't use "substr()" because it's not a
character column.  Any clues?



Please respond directly to me at sbrenner_at_attmail.com; I'll post the
answer (assuming I get it) in a few days.



a T d H v A a N n K c S e




Scott D. Brenner                  AT&T Consumer Communications Services
sbrenner_at_attmail.com                          Basking Ridge, New Jersey


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


Received on Fri Jul 16 1993 - 15:26:10 CEST












Original text of this message