Re: SQLPLUS - How to query long raw column?

From: <suisum_at_freenet.edmonton.ab.ca>
Date: 20 Sep 1998 21:26:59 GMT
Message-ID: <6u3rv3$v7k$1@news.sas.ab.ca>

Hi:

Have you tried the following:

SET LONG 1 Best regards,

Dwight Long (dclong_at_cjnetworks.com) wrote:
: I've got several tables which store data in long columns. How do I query
: and extract long values to a file?
: This doesn't work - it just displays a few lines of garbage.
: select long_result_column from the_table where long_result_id =
: x;

: sqlplus help on 'long' and 'raw' doesn't give a good example of how to
: use them in a query.

--
Best regards, Received on Sun Sep 20 1998 - 16:26:59 CDT