- 博客(5)
- 资源 (2)
- 收藏
- 关注
RSS订阅原创 存储过程2
create or replace procedure save_certr(certIds in varchar2,appids in varchar2) is sys_id varchar2(50); cursor zizhi is select * from t_en_arc_qualification@bmrpdblink n where n.certid
2014-11-25 11:20:52
218
原创 存储过程
create or replace procedure save_namic(dydispatchids in varchar2, businessRegistrationname in varchar2, state
2014-11-25 11:19:42
221
原创 sql之行列转换备份
select bustype, tx.anshi,tx.chaoshi,tx.weibanjie,(CASE WHEN (tx.anshi+tx.chaoshi+tx.weibanjie) = 0 THEN 0 ELSE round(tx.anshi*100/(tx.anshi+tx.chaoshi+tx.weibanjie),2) END) bjlv fro
2014-11-07 15:10:34
232
原创 sql语句row_number() OVER用法
select * from (select id1,id2 from ( select distinct row_number() OVER(PARTITION BY ob.id ORDER BY ob.id) n, SYS_GUID() as id1,
2014-11-07 15:07:56
452
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人