orcleプロパティフィールドを変更し、元の値を保持

update table1 set num = substr(num,0,instr(num,'-'))||(substr(num,instr(num,'-')+1) +9) 

2.         +  

UPDATE table1SET num = num+10 

3.   update tc_report t set xlsfile=substr(xlsfile,6) where xlsfile like '%uku\%'