Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT *
- FROM spraddr
- WHERE nvl (spraddr_from_date, to_date ('01-JAN-1900', 'DD-MON-YYYY')) <= sysdate
- AND nvl (spraddr_to_date, to_date ('31-DEC-2099', 'DD-MON-YYYY')) >= sysdate
- AND spraddr_status_ind IS NULL
Add Comment
Please, Sign In to add comment