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

From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Tue, 21 Oct 2008 10:17:12 -0700 (PDT)
Message-ID: <320659.71380.qm@web65704.mail.ac4.yahoo.com>


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
Received on Tue Oct 21 2008 - 12:17:12 CDT

Original text of this message