oracle 常用查询语句

1  oracle子查询同时更新多个列

    update test  set (a,b)=(select 1,2 from dual);

2 oracle  in子查询使用多个列

    select * from test where (a,b) in (select 1,2 from dual);

3 递归查询父节点

        select id from t_rlzy_zzjg start with id=10000 connect by prior sjid=id

4递归查询子节点

       select id from t_rlzy_zzjg start with id=10000 connect by prior id=sjid