Advertisement
Guest User

Untitled

a guest
Jun 24th, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT limit, CASE TYPE WHEN 'DEFAULT' THEN 0 ELSE 1 END AS GROUP
  2. FROM PPF_FUPLIMIT
  3. WHERE (iddocument = inIdDocument OR TYPE = 'DEFAULT')
  4. AND Valid = 'Y'
  5. AND ROWNUM < 2
  6. AND SYSDATE BETWEEN ValidFrom AND ValidTo ORDER BY createdat;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement