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