Re: [Q] shrink varchar2 size and truncate data????

something like
update table set INSTRUCTIONS = substr(INSTRUCTIONS,1,1000) where length(INSTRUCTIONS)>1000;
?

• On Tue, 10/21/08, dba1 mcc <mccdba1_at_yahoo.com> wrote:

> From: dba1 mcc <mccdba1_at_yahoo.com>
> Subject: [Q] shrink varchar2 size and truncate data????
> To: oracle-l_at_freelists.org
> Date: Tuesday, October 21, 2008, 1:17 PM
> we have a table has a field define as
> "varchar2(2000)", we tried to change size from
> varchar2(2000) TO VARCHAR2(1000).  dUE TO SOME RECORDS DATA
> LARGE THAN 1000. 
>  
> I can use following sql statemnet to find which records 
> > 1000 characters, but how can I truncate data larger
> than 1000 characters?
>  
> select id, length(INSTRUCTIONS) from functions where
> length(INSTRUCTIONS) >=1000;
      

--
http://www.freelists.org/webpage/oracle-l