아래 쿼리에서요 굵게 표시된 부분에서 조회된 값을 제외한 값이 나오는 쿼리인데요
여기서 값이 없으면 전체 값이 아예 안나옵니다..;;
조회값이 없어도 전체 값은 나오게 수정하려면 굵게 표시된 쿼리부분에서
어떤 작업을 하면 되나요? 조언바랍니다~
SELECT CATEGORYID,
TITLE,
DESCRIPTION,
RGST_USERID,
RGST_USERNAME,
CATEGORY_TYPE,
TRNS_SRC,
TRNS_KEY,
ISVISB,
MOBILE_USE,
SCRT_LEVEL
FROM (SELECT list.CATEGORYID,
list.TITLE,
list.DESCRIPTION,
list.RGST_USERID,
list.RGST_USERNAME,
list.CATEGORY_TYPE,
list.TRNS_SRC,
list.TRNS_KEY,
list.ISVISB,
list.MOBILE_USE,
list.SCRT_LEVEL
FROM plan_category list
WHERE isvisb = 1
AND (list.scrt_level < 6000 OR EXISTS (SELECT categoryid
FROM plan_category_scrt
WHERE categoryid = list.categoryid
AND groupid IN (?, ?)
)
)
) a
WHERE CATEGORYID not in (SELECT TO_NUMBER(TRIM(CATEGORYID)) as CATEGORYID
FROM (SELECT REGEXP_SUBSTR(CATEGORYID, '[^,]+', 1, LEVEL) AS CATEGORYID
FROM (SELECT to_char(CATEGORY_LIST) as CATEGORYID
FROM KMSUSR.hr_user_plan
WHERE userid = 사번
) b
CONNECT BY REGEXP_SUBSTR(CATEGORYID, '[^,]+', 1, LEVEL ) IS NOT NULL
) c
)
ORDER BY CATEGORYID asc