随笔分类 - Oracle Analytic

oracle row/column

摘要：LISTLAG LISTAGG function SyntaxAggregate Syntax: LISTAGG(measure_expr [, 'delimiter']) WITHIN GROUP (order_by_clause) Analytic Syntax : LISTAGG(measur 阅读全文

posted @ 2021-05-06 23:51 InnoLeo 阅读(97) 评论(0) 推荐(0)

oracle 树形查询，自连接查询

摘要：例1 select employee_id, first_name,last_name,manager_id from employees start with employee_id=100 connect by prior employee_id=manager_id 1 Steven King 阅读全文

posted @ 2021-05-06 23:33 InnoLeo 阅读(234) 评论(0) 推荐(0)