Guest User

Untitled

a guest
Aug 13th, 2018
107
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. (CASE WHEN cl.area_id IS NOT NULL THEN
  2.               (SELECT SUBSTR(SYS_CONNECT_BY_PATH(art.area_name,'  '),10)
  3.                 FROM area_tree art
  4.                WHERE art.parent_id IS NULL
  5.                START WITH art.area_id = cl.area_id
  6.              CONNECT BY PRIOR art.parent_id = art.area_id)
  7.            ELSE
  8.               NULL
  9.       END) AS area
RAW Paste Data