Oracle Pagenation 換頁

Pagenation 換頁 :
SELECT * from (select n.*,rownum num from XX.TABLE1 n WHERE rownum <=100) where num >= 50;
//第50~100筆

Oracle Time Format (to_char,to_date)

select to_char(sysdate,'YYYY/MM/DD HH:MI:SS') FROM DUAL;

select count(column) from table t
where date >to_date('2007/09/01 01:01:01','YYYY/MM/DD HH24:MI:SS')