Kamis, 06 Agustus 2015

Generate Range Tanggal di Oracle

Posted on 17.27 by Thinkerboy
Query generate range tanggal di Oracle :

SELECT
  TRUNC(SYSDATE - ROWNUM) dt
FROM
  DUAL CONNECT BY ROWNUM <= 7
ORDER BY dt DESC

Hasilnya seperti berikut :


Posted in , , |