oracle with oralce 9i以降で使える

with_select.sql

with
  view01 as 
	(SELECT
        id
    FROM
        tb1
    WHERE
        id = '01'
    )
SELECT
	view01.id, tb2.id
FROM 
	tb2, view01
WHERE
    tb2.id = view01.id