select * from tb_menu m start with m.id=2 connect by prior m.parent= m.id;找2的父节点，select * from tb_menu m connect by prior m.id= m.parent start with m.id=2;找2的子节点
select * from t_s_fun aCONNECT BY C_FUN_CODE = PRIOR C_FUN_CODE_P START WITH C_FUN_CODE IN ('AccSubject') 1） 首先，执行的是该select语句中的start with子句部分2）接着，执行的是该select语句中的connect by子句部分 pri...
一、简介 在oracle中start with connect by (prior) 用来对树形结构的数据进行查询。其中start with conditon 给出的是数据搜索范围, connect by后面给出了递归查询的条件,prior 关键字表示父数据，prior 条件表示子数据需要满足父数据的什么条件。如下start with id= '10001' connect by prior p
[oracle@redhat4 ~]$ lsnrctl status LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 06-OCT-2015 21:10:05 Copyright (c) 1991, 2009, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRES...
Mount Options for Oracle files for RAC databases and Clusterware when used with NFS on NAS devices (Doc ID 359515.1)In this DocumentPurposeScopeDetailsRAC including RACone and single instance RACRefer
Oracle中的select语句可以用start with...connect by prior子句实现递归查询，connect by 是结构化查询中用到的，
其基本语法是：
select ... from <TableName>where <Conditional-1>start with <Conditional-2>connect by <Condi
