「Oracle入門」階層問い合わせ(start with connect by)をするサンプル
サンプル
select *
from tableName t
start with t.columnName_A = 'value’
connect by prior t.columnName_B = t.columnName_A
Coding Changes the World
サンプル
select *
from tableName t
start with t.columnName_A = 'value’
connect by prior t.columnName_B = t.columnName_A