connect by prior
时间: 2023-09-09 20:10:40 浏览: 87
在Oracle中,connect by prior是一种用于执行递归查询的语法。它允许我们在查询中使用prior关键字来指定先前行与当前行之间的关系。通过使用connect by prior,我们可以创建层次结构查询,即树形查询。
connect by prior可以用两种方式来进行树查询:自顶而下和自底而上。自顶而下的查询方法是从根节点开始,逐层向下查询,
#### 引用[.reference_title]
- *1* *3* [Oracle SQL小示例系列-connect by prior](https://blog.csdn.net/chyanwu68/article/details/103861727)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
- *2* [Oracle递归查询start with connect by prior的用法](https://download.csdn.net/download/weixin_38632146/12824513)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]