Query:
select rownum, nt.* from notas_fiscais nt where nt.data_venda = to_date('10/01/2017','DD/MM/YYYY') and rownum <=10;
Resultado:
1 9283760794 00237 10-JAN-17 55166 0.1
2 19290992743 00236 10-JAN-17 55167 0.12
3 2600586709 00236 10-JAN-17 55168 0.12
4 7771579779 00236 10-JAN-17 55169 0.12
5 1471156710 00236 10-JAN-17 55170 0.1
6 50534475787 00237 10-JAN-17 55171 0.1
7 7771579779 00237 10-JAN-17 55172 0.12
8 9283760794 00237 10-JAN-17 55173 0.1
9 3623344710 00237 10-JAN-17 55174 0.1
10 2600586709 00236 10-JAN-17 55175 0.1
