【SQL开源代码栏目提醒】:以下是网学会员为您推荐的SQL开源代码-24.4.1.sql,希望本篇文章对您学习有所帮助。
--自定义PLAN_TABLE输出
SELECT cardinality "rows",
Lpad(' ',4*(level-2))||
Operation||' '||
Options||' '||
Object_name "Execution_Plan"
FROM PLAN_TABLE
START WITH id = 0
AND statement_id = 'st1'
CONNECT BY prior id = parent_id
AND prior statement_id = statement_id;