两表连接更新
update pcedm a set table_ename=(select table_ename from pcedm2 b where b.table_name=a.table_name);
本表更新
update pcedm a set a.data_type2=substr(data_type,1,instr(data_type,'(',1,1)-1)
---对于空的判断是逻辑判断,要写逻辑表达方式,不能写=NULL或者='';
实例:
update pcedm a set a.data_type2='DATE' WHERE A.DATA_TYPE2 IS NULL;
---更新提取长度。
update pcedm a set a.data_LENGTH=substr(data_type,instr(data_type,'(',1,1)+1,instr(data_type,')',1,1)-instr(data_type,'(',1,1)-1);
--更新精度
update pcedm a set a.data_SCALE=substr(data_length,instr(data_length,',',1,1)+1,1)
where length(data_length)!=length(replace(data_length,',','')) ;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9778796/viewspace-592095/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9778796/viewspace-592095/