Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Log Column Update 7.3
Unfortunately the subject line states that this is on 7.3.
There are some interesting pages on using the sqlplus copy command for longs on thomas kytes pages. Otherwise use your favourite programming language to manipulate the data programmatically.
7.3 is long since desupported and , as you are finding 8i has some nice features which address some of its shortcomings.
-- Niall Litchfield Oracle DBA Audit Commission UK "Rafal Jank" <yankee_at_wp-sa.pl> wrote in message news:3B1E2826.CAA5648A_at_wp-sa.pl...Received on Wed Jun 06 2001 - 09:42:38 CDT
> sam pal wrote:
> >
> > Hi
> > How can I update the Long Column?. The data is more than 32k.
> >
> By changing them to clob columns, and then using functions from dbms_lob
> package.
> Rafal
> --
> _/ _/ _/_/_/ ----- Rafa³ Jank yankee_at_wp.pl -----
> _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
> _/_/_/_/ _/_/_/ ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625
> _/ _/ _/ --------==* http://szukaj.wp.pl *==----------