start with to_date('10-10-2016 13:59:51', 'dd-mm-yyyy hh24:mi:ss') next sysdate+1 as WITH t_date AS (SELECT to_date('20150601', 'yyyymmdd') - 1 + LEVEL d FROM dual CONNECT BY LEVEL <= trunc(SYSDATE) - to_date('20150601', 'yyyymmdd') + 1) 麻烦大神解释下这段sql的意思。 |