亚洲视频二区_亚洲欧洲日本天天堂在线观看_日韩一区二区在线观看_中文字幕不卡一区

關系表：sys_function

id ：主鍵id

pid：父關系id

Oracle函數：start with…connect by…prior

1.表數據

select * from family;

2.查詢自己和自己所有的后代

select s.*

from family s

start with s.id = 'me'

connect by prior s.id = s.pid;

3.查詢自己和自己的祖先

select s.*

from family s

start with s.id = 'me'

connect by s.id = prior s.pid;

4.查詢自己所有的后代(不包括自己)

select s.*

from family s

start with s.pid = 'me'

connect by prior s.id = s.pid;

5.查詢自己的第一代孩子和祖先(包括自己)

select s.*

from family s

start with s.pid = 'me'

connect by s.id = prior s.pid;