可與 INNER JOIN / OUTER JOIN 一起使用.

SELECT product , part , Level

FROM bom

START WITH product ='ProductName'

CONNECT BY PRIOR part = product

arrow
arrow
    文章標籤
    oracle sql 鼎新 遞迴
    全站熱搜

    伊 發表在 痞客邦 留言(0) 人氣()