「Oracle入門」階層問い合わせ(start with connect by)をするサンプル

サンプル
select *
from tableName t
start with t.columnName_A = ‘value’
connect by prior t.columnName_B = t.columnName_A

Comments are closed.