![](https://img-blog.csdnimg.cn/20201014180756930.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql_oracle
斯文的很败类
2
展开
-
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 · 224 阅读 · 0 评论 -
存储过程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 · 208 阅读 · 0 评论 -
存储过程
create or replace procedure save_namic(dydispatchids in varchar2, businessRegistrationname in varchar2, state原创 2014-11-25 11:19:42 · 213 阅读 · 0 评论 -
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 · 439 阅读 · 0 评论