Re: Printing ASCII text stored in a LONG field

Paul Curtis <pcurtis_at_iconnet.com> wrote:
>What I have is a long field in a table that contains ASCII text. What I
>need to do is access the ASCII text using SQL*Plus. What I get currently
>using "SELECT field FROM table" is the hex codes representing the ASCII
>text in the field.
>
>I know that there must be a way to do this. A function, some PL/SQL
>perhaps? Please help as the deadline for this rapidly approaches.
>
>Paul
>pcurtis_at_iconnet.com

Hi there,

I am quite surprised that an hexa decimal value is retrieved through your select statement

Try the following.

set long 100000
select long_column from table

Please let me know about your findings.

Regards

N.Prabhakar Received on Thu Nov 28 1996 - 00:00:00 CET