Oracle递归查询同级或上级

一、建表及插入数据

ocation_id	location_name	parent_location_id
1	广东省	NULL
2	广州市	1
3	深圳市	1
4	天河区	2
5	番禺区	2
6	南山区	3
7	宝安区	3

建表sql在上篇文章

二、递归查询获取宝安区上级所有地区

SELECT *
FROM locations
START WITH location_name = '宝安区'
CONNECT BY PRIOR parent_location_id = location_id;

三、查询与宝安区同级地区

SELECT * 
FROM locations 
WHERE parent_location_id = (SELECT parent_location_id FROM locations WHERE location_name = '宝安区');