Oracle数据库操作

• Oracle获取各个时间点：

SELECT TRUNC(LAST_DAY(SYSDATE)+1+8/24) + 9 / 24 + 0 / 24 / 60 + 0 / 24 / 60 / 60 FROM DUAL

SELECT TRUNC(SYSDATE)+0/24 FROM DUAL;     --当天0点

SELECT TRUNC(SYSDATE)+9.5/24 FROM DUAL;  --当天9点半

SELECT TRUNC(SYSDATE)+12/24 FROM DUAL;   --当天中午12点    

•  Oracle拆分逗号隔开列为多行

SELECT CK_PERSON FROM 
 (SELECT REGEXP_SUBSTR(字段, '[^,]+', 1,LEVEL) 字段
    FROM (SELECT * FROM 表名 WHERE CK_FLAG=0 AND
      CREATETIME=(select trunc(sysdate, 'mm') from dual))
      CONNECT BY LEVEL <= REGEXP_COUNT(字段, '[^,]+')
      AND ROWID = PRIOR ROWID
      AND PRIOR DBMS_RANDOM.VALUE IS NOT NULL
   ORDER BY 字段)
GROUP BY 字段;