Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT TO_DATE('01/07/2010','dd/mm/yy') + ROWNUM
- FROM tabla t
- WHERE TO_DATE('01/07/2010','dd/mm/yy') + ROWNUM < TRUNC(SYSDATE)
- MINUS
- SELECT DISTINCT t2.fecha
- FROM tabla t2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement