SQL拼接父级字符串

select group_uuid,
         LTRIM(sys_connect_by_path(group_name, '-->'), '-->') as group_name
    from ORG_GROUP2 GG
   where GG.LOGICDELETE = '0'
   start with GG.group_uuid = '-1'
  connect by GG.parent_uuid = prior GG.group_uuid

从prior开始去查另一侧