Advertisement
psi_mmobile

Untitled

Nov 27th, 2019
453
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.81 KB | None | 0 0
  1. --before
  2. SELECT WorkCode.WORK_CODE_ID,
  3.        WorkCode.VEHICLE_OWNER_ID,
  4.        WorkCode.WORK_CODE_NAME,
  5.        WorkCode.SHORT_CODE,
  6.        WorkCode.LM_COMMENT,
  7.        WorkCode.WORK_CODE_STD_ID,
  8.        WorkCode.ORDER_NUM,
  9.        WorkCode.MOBILITY_IS_PAID
  10. FROM WORK_CODE WorkCode
  11. WHERE VEHICLE_OWNER_ID = ?
  12. ORDER BY ORDER_NUM ASC
  13.  
  14. --after
  15.  
  16. SELECT WorkCode.WORK_CODE_ID,
  17.        WorkCode.VEHICLE_OWNER_ID,
  18.        WorkCode.WORK_CODE_NAME,
  19.        WorkCode.SHORT_CODE,
  20.        WorkCode.LM_COMMENT,
  21.        WorkCode.WORK_CODE_STD_ID,
  22.        WorkCode.ORDER_NUM,
  23.        WorkCode.MOBILITY_IS_PAID
  24. FROM WORK_CODE WorkCode, GUI_USERS GuiUsers, STR Str
  25. WHERE WorkCode.STR_ID = Str.STR_ID(+)
  26. AND GuiUsers.LANGUAGE = Str.STR_ID(+)
  27. AND GuiUsers.GUI_USER_ID = ?
  28. AND WorkCode.VEHICLE_OWNER_ID = ?
  29. ORDER BY ORDER_NUM ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement