- 博客(4)
- 资源 (25)
- 收藏
- 关注
原创 Oracle 批量替换字段中的字符
/*update SQL:执行一个语句把字段中%替换成''*/ update web_traffic_data_raw set ubi_bounce_rate=replace(ubi_bounce_rate,'%','') where web_id=1811 commit; /*先把%去掉然后除以100再转化成char类型*/ update web_traffic_data_
2012-06-29 14:14:21 9660
Oracle 批量替换字段中的字符
/*update SQL:执行一个语句把字段中%替换成''*/ update web_traffic_data_raw set ubi_bounce_rate=replace(ubi_bounce_rate,'%','') where web_id=1811 commit; /*先把%去掉然后除以100再转化成char类型*/ update web_traffic_data_...
2012-06-29 14:14:00 728
原创 创建一个trigger
create or replace trigger wid_iwm_new_id_tri before insert on web_iwm_data_raw for each row declare -- local variables here begin select WEB_SPLIT_IWM_SEQ.NEXTVAL into :new.id from dual;
2012-06-28 20:09:26 532
创建一个trigger
create or replace trigger wid_iwm_new_id_tri before insert on web_iwm_data_raw for each row declare -- local variables here begin select WEB_SPLIT_IWM_SEQ.NEXTVAL into :new.id from dual;...
2012-06-28 20:09:00 129
mybatis-generator-core-1.3.5.jar 生成实体及DAO命名优化
2018-09-20
SpringCloud Eureka搭建微服务
2018-09-05
SpringMVC+spring+mybatis框架整合
2017-04-24
JqGrid 纯Json自带分页功能
2012-12-11
Spring +MVC+ Freemarker 学习资料
2012-10-06
CSS sprites
2011-03-25
debugbar-v5.4.1
2010-09-20
源代码查看器-EditPlus
2010-09-15
HTML文本编辑器绿色免费
2010-08-17
Jmail44_free
2010-08-13
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人