HIER_CONDITION ( member_expr IS [NOT] [ IN member_set | { PARENT | CHILD | ROOT ANCESTOR | [LEAF] DESCENDANT | SIBLING | ANCESTOR AT LEVEL level } [OR SELF] OF ] WITHIN HIERARCHY hierarchy_ref [{ INCLUDE | SKIP } WHEN NULL] )