Re: [Q] shrink varchar2 size and truncate data????
- From: Guang Mei <guangmei@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx, mccdba1@xxxxxxxxx
- Date: Tue, 21 Oct 2008 10:36:20 -0700 (PDT)
something like
update table set INSTRUCTIONS = substr(INSTRUCTIONS,1,1000)
where length(INSTRUCTIONS)>1000;
?
--- On Tue, 10/21/08, dba1 mcc <mccdba1@xxxxxxxxx> wrote:
> From: dba1 mcc <mccdba1@xxxxxxxxx>
> Subject: [Q] shrink varchar2 size and truncate data????
> To: oracle-l@xxxxxxxxxxxxx
> 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;
--
//www.freelists.org/webpage/oracle-l
Other related posts:
