Very Computer

HI.

I know this is a simple question, but I can't find the answer in any  of my
Oracle documentation.

How do I view the entire contents of a text column?  I am selecting the
text column from a table, and I am limited to what contents I can see -
SQL/Plus cuts it off.

Thanks!

Hi Laura.

If it is a LONG column you must set the LONG-system variable to
a higher value.

For example type this in SQL*Plus:

        set LONG 10000

Maximum is 2 Giga in ORACLE7.

Greez,
Angelo.

--
-----------------------------------------------------------------
Angelo Cavallaro     /  /  /   \     TECTUM Beratungsgesellschaft
ORACLE-SW-Berater   /  /  /     \    fr Informationsverarbeitung

-----------------------------------------------------------------
         Visit the Home of the Green Ribbon Campaign:

                http://www.ponce.oisoft.com/

-----------------------------------------------------------------

(if that email address didn't require changing)

SQL> set long 99999

SQL> show long
long 99999

SQLPlus will only show the initial 'long' bytes of LONG field.  By default this
is 5,000 characters. Just issue set long "some bigger number" to see more of it.

Thomas Kyte

Oracle Government
Bethesda MD

http://govt.us.oracle.com/    -- downloadable utilities

----------------------------------------------------------------------------
Opinions are mine and do not necessarily reflect those of Oracle Corporation

Anti-Anti Spam Msg: if you want an answer emailed to you,
you have to make it easy to get email to you.  Any bounced
email will be treated the same way i treat SPAM-- I delete it.

I think

    SET LONG <n>

should do the trick.

Where n is the number of characters you want to be displayed.

HTH