マネージャー階層 - 日本語キャプション付き

avt_employee_hier_with_caption.sql

create or replace hierarchy avt_employee_hier
    /* ALL_HIER_CLASS */
    classification caption value 'Manager Dimension'
    classification caption value 'マネージャー・ディメンジョン' language 'JAPANESE'
using avt_emp_dim 
(
    emp child of
    lvl3_mgr child of
    lvl2_mgr child of
    lvl1_mgr
)
/* ALL_HIER_HIER_ATTR_CLASS */
hierarchical attributes (
    member_name 
        classification caption value 'Member Name'
        classification caption value 'メンバー名' language 'JAPANESE'
    , member_unique_name
        classification caption value 'Member Unique Name'
        classification caption value 'メンバー一意名' language 'JAPANESE'
    , member_caption
        classification caption value 'Member Caption'
        classification caption value 'メンバーの説明' language 'JAPANESE'
    , member_description
        classification caption value 'Member Description'
        classification caption value 'メンバーの詳細' language 'JAPANESE'
    , level_name
        classification caption value 'Level Name'
        classification caption value 'レベル名' language 'JAPANESE'
    , hier_order
        classification caption value 'Hier Order'
        classification caption value '階層の順序' language 'JAPANESE'
    , depth
        classification caption value 'Depth'
        classification caption value '深さ' language 'JAPANESE'
    , is_leaf
        classification caption value 'Is Leaf'
        classification caption value '末端' language 'JAPANESE'
    , parent_level_name
        classification caption value 'Parent Level Name'
        classification caption value '親レベル名' language 'JAPANESE'
    , parent_unique_name
        classification caption value 'Parent Unique Name'
        classification caption value '親一意名' language 'JAPANESE'
)
;