select level /*层级*/
, sys_connect_by_path(table_a.pk_sup,' ') pk_sup_link /*父级主键链接*/
from table_a /*表名*/
start with table_a.pk_sup is null /*顶级节点*/
connect by table_a.pk_sup=prior table_a.pk /*链接条件*/
select level /*层级*/
, sys_connect_by_path(table_a.pk_sup,' ') pk_sup_link /*父级主键链接*/
from table_a /*表名*/
start with table_a.pk_sup is null /*顶级节点*/
connect by table_a.pk_sup=prior table_a.pk /*链接条件*/