查询今天数据: SELECT COUNT(1) FROM T_CALL_RECORDS WHERE TO_CHAR(T_RKSJ,'YYYY-MM-DD')=TO_CHAR(SYSDATE,'YYYY-MM-DD'): 查询昨天数据: SELECT COUNT(1) FROM T_CALL_RECORDS WHERE TO_CHAR(T_RKSJ,'YYYY-MM-DD')=TO_CHAR(SYSDATE-1,'YYYY-MM-DD'): 查询本周数据: SELECT COUNT(1) FROM
注:在之前工作的时候,数据需要根据时间查询出当月值和上月的值. 语法: WITH A AS( SELECT * FROM TABLE ), B AS (SELECT * FROM TABLE)SELECT * FROM A,B 注:个人理解为with后面跟着几张临时表,然后a为临时表名,可以有多张临时表,然后最后一个查询的表可以用临时表 例: WITH A AS( SELECT ID,TIME,SUM FROM TABLE ), B AS ( SELECT ID,TIME,SUM FROM TA
一,日期相关的函数 Select to_char(sysdate,'Q') from dual;--指定日期的季度 Select to_char(sysdate,'MM') from dual;--月份 Select to_char(sysdate,'WW') from dual;--当年第几周 Select to_char(sysdate,'W') from dual ;--本月第几周 Select to_char(sysdate,'DD') from dual;--当月第几天 Select
1.oracle字符串分割函数split )定义split_type类型: CREATE OR REPLACE TYPE split_type IS TABLE OF VARCHAR2 (4000) )定义split函数: CREATE OR REPLACE FUNCTION split ( p_str IN VARCHAR2, p_delimiter IN VARCHAR2 default(',') --分隔符,默认逗号 ) RETURN split_type IS