SHARE
TWEET

Untitled

a guest Nov 14th, 2017 46 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT created_date
  2. FROM tableName LOAN
  3. WHERE
  4. loan.created_date > sysdate - 11000
  5. AND loan.SYSTEM_ID ='ALS'
  6. AND loan.BANK_NUM = '021'
  7. AND loan.short_name like 'NAME%'
  8. AND trunc(loan.CREATED_DATE) BETWEEN TO_DATE('09-01-2017', 'MM-DD-YYYY')  
  9. AND TO_DATE('10-13-2017', 'MM-DD-YYYY')
RAW Paste Data
Pastebin PRO Autumn Special!
Get 40% OFF on Pastebin PRO accounts!
Top