CREATE OR REPLACE VIEW V_BUKA AS
SELECT
	 SUBSTR(名称ｷｰ2,1,1)	"部"
	,SUBSTR(名称ｷｰ2,2,1)	"課"
	,名称					"部課名"
FROM
    MM_MEI
WHERE
    名称ｷｰ1 = '課'
;