距离当前一个星期的记录:
select * from t_news n where n.edit_date >= trunc(sysdate)-7
层级树形查询 -包含父节点:
SELECT* FROM
T_COMMON_TYPE CC
START WITH CC.INFO_CODE = '202'
CONNECT BY PRIOR CC.INFO_CODE = CC.PARENT_INFO
距离当前一个星期的记录:
select * from t_news n where n.edit_date >= trunc(sysdate)-7
SELECT* FROM
T_COMMON_TYPE CC
START WITH CC.INFO_CODE = '202'
CONNECT BY PRIOR CC.INFO_CODE = CC.PARENT_INFO