SELECT TYPEID from tableName connect by PARENTID = prior TYPEID start with PARENTID =? )
typeid是主键,tableName是表名,parentid是父id,"=prior"是固定写法,start with表示从哪里开始,可以是typeid或parentid等。
oracle 处理树sql
最新推荐文章于 2017-05-19 09:15:55 发布
SELECT TYPEID from tableName connect by PARENTID = prior TYPEID start with PARENTID =? )
typeid是主键,tableName是表名,parentid是父id,"=prior"是固定写法,start with表示从哪里开始,可以是typeid或parentid等。