查离有效期至多只有七天的商品的商品

select * from abc  where trunc(add_months(to_date(InLiBDate,'yyyy-mm-dd'),StorageLife*12))-trunc(sysdate) between -7 and 0