Re: Working with CLOBS in SQLPLUS
From: Keith Jamieson <Keith.Jamieson_at_phoenix.ie>
Date: Thu, 4 Jan 2001 15:59:46 -0000
Message-ID: <9326qi$5ld$1_at_kermit.esat.net>
Date: Thu, 4 Jan 2001 15:59:46 -0000
Message-ID: <9326qi$5ld$1_at_kermit.esat.net>
for clobs,lobs you have to use as a minimum an anonymous pl/sql block. You also need to have the manual handy.
for long columns just set long xxxx where x is big enough.
p_forman_at_my-deja.com wrote in message <92gp7o$b2d$1_at_nnrp1.deja.com>...
>Anyone have any tips and hints for working with (mainly displaying)
>CLOB and Long columns while working withing SQL Plus.
>
>Thanks,
>
>Perry
>
>
>Sent via Deja.com
>http://www.deja.com/
Received on Thu Jan 04 2001 - 16:59:46 CET