DimitarVasilev

Untitled

May 9th, 2017
42
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.21 KB | None | 0 0
  1. SELECT to_char(date_day, 'fm Day "-" dd.mm.yyyy') DATE_DAY,
  2.   TRF_DHR_SUPP_TO_PAY,
  3.   TRF_DHR_SUPP_TO_STORE,
  4.   VEHICLE_ID,
  5.   nvl2(MEAL_ALLOWANCE, 'Y', 'N') MEAL_ALLOWANCE
  6. FROM pd_day
  7. WHERE person_id ='&person_id';
Add Comment
Please, Sign In to add comment