daily pastebin goal
68%
SHARE
TWEET

Untitled

a guest Aug 10th, 2018 62 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select haou.date_from,
  2.        haou.attribute1 || ' ' || haou.name,
  3.        haou.organization_id,
  4.     uoepp.uoe_functions.uoe_get_college_org_code(haou.organization_id) L3,
  5.      uoepp.uoe_functions.uoe_get_school_org_code(haou.organization_id) L4,
  6.     (select listagg(organization_id, ',') within group (order by haou1.organization_id )from hr_all_organization_units haou1
  7.     where haou1.attribute1 = haou.attribute1)
  8. from hr_all_organization_units haou
  9. where date_from = '01-AUG-2018 00.00.00'
  10. order by uoepp.uoe_functions.uoe_get_college_org_code(haou.organization_id), uoepp.uoe_functions.uoe_get_school_org_code(haou.organization_id);
  11.  
  12.  
  13. select * from hr_all_organization_units where attribute1 = 'P7V'
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top