Re: display long and long raw?

From: Rognvald Bjarne <wear_u_out_at_nospam.hotmail.com>
Date: 2000/08/10
Message-ID: <ixDk5.8946$KFL5.94699813_at_news.randori.com>#1/1


"Steve Salvemini" <steve.salvemini_at_adelaide.edu.au> wrote in message news:3992268A.3DA1B2C4_at_adelaide.edu.au...
> I would like to display a long and a long raw field from a table (they
> contain text descriptions), in plsql or sqlplus, but how do you do it.
>
> Also, ideally, I would like to remove all blanks from the field for
> displaying, ie replace(col,' ','').
>
> Any ideas?

In 8i you could use DBMS_LOB; otherwise you're pretty much stuck with an API/OCI approach. Received on Thu Aug 10 2000 - 00:00:00 CEST

Original text of this message