oracle substr
oracle截取指定字段
select substr(sd.field_31,0,length(sd.field_31)-2) from sd ;
update sd set sd.field_31 = substr(sd.field_31,0,length(sd.field_31)-2) where sd.relate_fk='xxxxxx';
oracle substr
oracle截取指定字段
select substr(sd.field_31,0,length(sd.field_31)-2) from sd ;
update sd set sd.field_31 = substr(sd.field_31,0,length(sd.field_31)-2) where sd.relate_fk='xxxxxx';