Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT created_date
- FROM tableName LOAN
- WHERE
- loan.created_date > sysdate - 11000
- AND loan.SYSTEM_ID ='ALS'
- AND loan.BANK_NUM = '021'
- AND loan.short_name like 'NAME%'
- AND trunc(loan.CREATED_DATE) BETWEEN TO_DATE('09-01-2017', 'MM-DD-YYYY')
- AND TO_DATE('10-13-2017', 'MM-DD-YYYY')
Add Comment
Please, Sign In to add comment