今天刚遇到的问题,数据库了解的不多,第一次遇见这样的问题,记录下来以免忘记啊
数据库表为p_goods_type ,字段有 fid(主键) 、type_name、fparentid ,
查询父类id为“F1C77472AC770008E0437F0000010008”下的所有子类内容,显示方式: <手机/数码<相机,sql语句为:
select typename from(
select level as 等级,
connect_by_isleaf as 是否是叶子,
lpad(' ',level*2-1)||sys_connect_by_path(type_name,'<') as typename,
p.fid,
p.fparentid
from p_goods_type p
connect by prior p.fid=p.fparentid
start with p.fparentid is null
) where fparentid='F1C77472AC770008E0437F0000010008'
查询fid为“F1C77472AC770008E0437F0000010008”所对应的所有父类内容,sql语句如下
select typename from(
select level as 等级,
connect_by_isleaf as 是否是叶子,
lpad(' ',level*2-1)||sys_connect_by_path(type_name,'<') as typename,
p.fid,
p.groupid,
p.fparentid
from p_goods_type p
connect by prior p.fid=p.fparentid
start with p.fparentid is null
) where fid='F1C77472AC770008E0437F0000010008'select typename from(
具体的Connect By 、Level 、StartWith 的解释和使用,可参考下边网址
参考的文章: http://www.360doc.com/content/13/0422/16/11947209_280153192.shtml