последние измерения

select /*+ INDEX_DESC (t IDX$MEASURE$MEASURE_ID) */ * from measure t
order by measure_id desc