Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: &^@#%$@#%$ stinkin' oracle7 database
I think this will work only if the values in the LONG RAW column are
less than 32K (the maximum size of a varchar2 PL/SQL variable.) Your
note about 2000 being the limit might be related to the maximum size of
a varchar2 table column in Oracle 7?=20
-----Original Message-----
Barbara Baker
Matt:
doesn't need to be pro*c -- you can do it with pl/sql.
I believe this will work:
select rowid, SCN_DATA from SCN;
update T_SCN set T_SCN_DATA =3Dc1.SCN_DATA where rowid =3D c1.rowid;
I have a note to myself that the long needs to be <=3D 2000 characters, so I hope yours is. Can't remember why I have this note . . .
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlReceived on Fri May 07 2004 - 17:16:20 CDT
-----------------------------------------------------------------
![]() |
![]() |