쿼리문 분석하기
SELECT LEVEL LEV, NVL(M.AMA_IDX, 0) AMA_IDX, A.AMI_IDX, A.UP_AMI_IDX, NVL(M.MEM_IDX, 1) MEM_IDX, A.MENU_NAME, A.MODE_NAME , CASE WHEN A.VALUE_NAME IS NULL THEN (SELECT VALUE_NAME FROM ADMIN_MENU_INFO WHERE UP_AMI_IDX=A.AMI_IDX AND SORT=1 AND DEL_YN='N' AND VIEW_YN='Y') ELSE A.VALUE_NAME END VALUE_NAME, A.SORT , NVL(A.VIEW_YN, 'N') VIEW_YN, NVL(A.TAB_YN, 'N') TAB_YN , NVL(M.AUTH_L_YN, 'N') AUTH_L..
2021. 1. 21.