select *
from prd_rsl as of timestamp to_timestamp(‘20141021140000′,’yyyymmddhh24miss’)
where LOT_NO = ‘S000014900′
;

select *
from prd_rsl as of timestamp(systimestamp-interval ’30’ minute)
where LOT_NO = ‘S000014900’
;

특정시간이나 30분전으로 선택해서 이전의 데이터를 볼 수 있다.

Leave a Reply

Your email address will not be published.