Guest User

Untitled

a guest
Oct 20th, 2017
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.31 KB | None | 0 0
  1. -- MJ/MP nº 2321, de 30/12/2014
  2. -- MJ/MP nº 705, de 30/06/2015
  3. SELECT
  4. (98 - MOD(TO_NUMBER(SUBSTR('000806010000176201658', 1, 19)), 97)) as portaria_antiga,
  5. (98 - MOD(TO_NUMBER(SUBSTR('000806010000176201658', 1, 19)) * 100, 97)) as portaria_nova,
  6. TO_NUMBER(SUBSTR('000806010000176201658', -2)) as digito
  7. from dual;
Add Comment
Please, Sign In to add comment