Advertisement
psi_mmobile

Untitled

Apr 15th, 2021
1,226
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.42 KB | None | 0 0
  1. SELECT OcPoiCategory.OC_POI_CATEGORY_ID,
  2.        OcPoiCategory.NAME
  3. FROM OC_POI_CATEGORY OcPoiCategory, V_GUI_USER_OC_POI_CATEGORY VGuiUserOcPoiCategory, oc_day_aggreg OcDayAggreg
  4. WHERE VGuiUserOcPoiCategory.OC_POI_CATEGORY_ID = OcPoiCategory.OC_POI_CATEGORY_ID
  5. AND OcPoiCategory.OC_POI_CATEGORY_ID = OcDayAggreg.OC_POI_CATEGORY_ID
  6. AND OcDayAggreg.VO_PERSON_CATEGORY_ID = ?
  7. AND VGuiUserOcPoiCategory.GUI_USER_ID = ?
  8. ORDER BY 2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement