层级构造数据之查询SQL

SELECT level, t.id, t.name, t.parentid  FROM ST_MENU t START WITH t.id = 1CONNECT BY PRIOR t.id = t.parentid

SELECT level, t.id, t.name, t.parentid  FROM ST_MENU t START WITH t.id = 1010110CONNECT BY PRIOR t.parentid=t.id