应用举例:
au.hall.org.hiberarchy like o.hiberarchy||'%'
locate(o.hiberarchy,au.hall.org.hiberarchy)=1
au.hall.org.hiberarchy like '%'||o.hiberarchy||'%'
locate(o.hiberarchy,au.hall.org.hiberarchy)>0
au.hall.org.hiberarchy like '%'||o.hiberarchy
lcoate(o.hiberarchy,au.hall.org.hiberarchy)=-1
au.hall.org.hiberarchy like o.hiberarchy||'-%'
locate(o.hiberarchy||'-',au.hall.org.hiberarchy)=1