![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle
白开水先生
地球人
展开
-
Oracle动态生成两个年月之前包含的年月
SELECT TO_CHAR( ADD_MONTHS( TO_DATE(开始年月, 'yyyy-mm' ), ( ROWNUM - 1 ) ), 'yyyy-mm' ) 年月 FROM DUAL CONNECT BY ROWNUM <= MONTHS_BETWEEN( TO_DATE( 开始年月, 'yyyy-mm' ), TO_DATE( 结束年月, 'yyyy-mm' ) ) + 1; 条件: 开始年月 = ‘2020-02’, 结束年月=‘2020-04’ 结果: ...原创 2020-11-11 11:11:50 · 179 阅读 · 0 评论 -
Oracle根据表字段导出数据字典
WITH TEMP AS ( SELECT AC.COLUMN_NAME FROM SYS.ALL_CONS_COLUMNS AC, SYS.ALL_CONSTRAINTS AU WHERE AC.CONSTRAINT_NAME = AU.CONSTRAINT_NAME AND AC.OWNER = 'QBSGZTEST' AND AU.CONSTRAINT_TYPE = 'P' ), TEMP2 AS ( SELECT A.TABLE_NAME, A原创 2020-11-06 10:53:30 · 327 阅读 · 0 评论 -
oracle行转列,通用语句 有些版本不支持pivot
olracle 通用语句,有些版本不支持pivot SELECT SUM(DECODE(T.CHECKTYPE,‘待定’, T.COUNT,0)) AS WAIT, SUM(DECODE(T.CHECKTYPE,‘合格’,T.COUNT,0)) AS QUALIFIED, SUM(DECODE(T.CHECKTYPE,‘不合格’,T.COUNT,0)) AS NOTQUALIFIED FROM ( SELECT NVL( CHECKTYPE,‘待定’ ) AS CHECKTYPE, COUNT( 1 ) A原创 2020-11-04 16:20:18 · 453 阅读 · 0 评论