select KEY_ID,LOTNO, PROCESS, PROCESS_CNT,Level
from TRC_JR
start with PROCESS = ‘CA’
connect by prior PROCESS = PREV_PROCESS and prior PROCESS_CNT = PREV_PROCESS_CNT;

 

https://www.oracle.com/technetwork/jp/articles/otnj-sql-image6-1352144-ja.html#e