追梦人

package com.alibaba.itbu.billing.framework.util; import org.springframework.beans.factory.NoSuchBeanDefinitionException; import org.springframework.context.ApplicationContext; import org.sprin...

以前处理故障时候，遇到特殊情况下，表中的数据出现重复，可以巧用rowid 处理重复数据 create table test1(id integer,city varchar2(100),levle varchar2(4)); select * from test1; insert into test1 values(1,'hangzhou','1'); insert into tes...

  package com.alibaba.china.biz.common.util; /** * <PRE> * 提供对字符串的全角->半角，半角->全角转换 * @author laurence 2007-11-16 上午11:47:22 * </PRE> */ public class BCConvert...

begin for x in ( select order_id, rownum r from billing_order where status != 'closed' and pc2_type = '1' ) loop update billing_order set pc2_type = '4',gmt_modified = sysdate ...