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

How about this?    

create table tomtest(col1 varchar2(6))

insert into tomtest values('abcdev')

update tomtest

set col1=substr(col1,1,4);

alter table tomtest modify(col1 varchar2(4));      

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dba1 mcc Sent: Tuesday, October 21, 2008 1:17 PM
To: oracle-l_at_freelists.org
Subject: [Q] shrink varchar2 size and truncate data????  

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