借助新技术提升数据库开发效率.pdf

新技术提升数据库开发效率 演讲人：韦伟 全球敏捷运维峰会 广州站 一道面试题 某支股票最长连续涨了多少交易日 1 select max(连续日数) 2 from (select count(*) 连续日数 3 from (select sum(涨跌标志) over(order by 交易日) 不涨日数 4 from (select 交易日, 5 case when 收盘价lag(收盘价) over(order by 交易日) 6 then 0 else 1 end 涨跌标志 7 from 股价表) ) 8 group by 不涨日数) SQL 全球敏捷运维峰会 广州站 更复杂的SQL PROCEDURE SaleGoodsDayTpRt(in_store IN VARCHAR2, IF SQL%ROWCOUNT = 0 OR SQL%ROWCOUNT IS NULL THEN in_billno IN VARCHAR2, RETURN; in_billid IN VARCHAR2, END IF; in_rq IN VARCHAR2, INSERT INTO tmp_selldetail in_sj IN VARCHAR2) SELECT * FROM IV_ORD_DETAIL_zjl IS WHERE STR = in_store AND RQ = in_rq AND DH = in_billno lstore ba_area%ROWTYPE; AND DJLX = in_billid AND SJ = in_sj ltime dim_times%ROWTYPE; AND sn = 10; lsale SALEGOODSDAYTPRT%ROWTYPE; IF SQL%ROWCOUNT = 0 OR SQL%ROWCOUNT IS NULL THEN lhead tmp_sellhead%ROWTYPE; raise_Application_Error(ErrCode,销售明细不存在!); ldet tmp_selldetail%ROWTYPE; END IF; lpay tmp_sellpay%ROWTYPE; INSERT INTO tm