我想找到一颗树里面符合条件的节点
条件语句应该怎么写?
SELECT distinct ID FROM table1 START WITH ID 1 CONNECT BY PRIOR ID = PARENT_ID
如果我想找table1表里面B字段非空的ID
应该怎么写??
谢谢
---------------------------------------------------------------
SELECT distinct ID FROM table1 START WITH ID 1 CONNECT BY ( PRIOR ID = PARENT_ID
AND b is not null )