Advertisement
xaquinvp

Atopar elementos que faltan nunha táboa

Oct 22nd, 2012
392
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.17 KB | None | 0 0
  1. SELECT TO_DATE('01/07/2010','dd/mm/yy') + ROWNUM
  2. FROM tabla t
  3. WHERE TO_DATE('01/07/2010','dd/mm/yy') + ROWNUM < TRUNC(SYSDATE)
  4. MINUS
  5. SELECT DISTINCT t2.fecha
  6. FROM tabla t2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement