gkpoll

Untitled

Feb 22nd, 2019
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.37 KB | None | 0 0
  1. SELECT usr.tus_cod_usr AS "COD USUARIO",
  2.        usr.tus_fec_ult_con AS "ULTIMA CONEXAO SAT",
  3.        ADD_MONTHS(usr.tus_fec_ult_con, 18) AS "DATA INATIVACAO"
  4. FROM tab_user usr
  5. WHERE usr.tus_orig_usr IN (1,4,5)
  6. AND usr.tus_status=1
  7. AND MONTHS_BETWEEN(SYSDATE, usr.tus_fec_ult_con) > 17
  8. AND MONTHS_BETWEEN(SYSDATE, usr.tus_fec_ult_con) < 18
  9. ORDER BY usr.tus_fec_ult_con DESC;
Advertisement
Add Comment
Please, Sign In to add comment