programmers : 경기도에 위치한 식품창고 목록 출력하기

경기도에 위치한 식품창고 목록 출력하기

MYSQL

IFNULL

SELECT WAREHOUSE_ID, WAREHOUSE_NAME, ADDRESS, 
IFNULL(FREEZER_YN, 'N') FREEZER_YN
FROM FOOD_WAREHOUSE 
WHERE ADDRESS LIKE '경기%'
ORDER BY WAREHOUSE_ID ;

CASE WHEN THEN END

SELECT WAREHOUSE_ID, WAREHOUSE_NAME, ADDRESS,
       (CASE WHEN FREEZER_YN IS NULL THEN 'N'
        WHEN FREEZER_YN = 'Y' THEN 'Y'
        WHEN FREEZER_YN = 'N' THEN 'N' END) FREEZER_YN
FROM FOOD_WAREHOUSE 
WHERE ADDRESS LIKE '경기%'
ORDER BY WAREHOUSE_ID ;

 

 

ORACLE 

NVL

SELECT WAREHOUSE_ID, WAREHOUSE_NAME, ADDRESS, NVL(FREEZER_YN, 'N') AS FREEZER_YN
FROM FOOD_WAREHOUSE 
WHERE ADDRESS LIKE '경기%'
-- WHERE REGEXP_LIKE(ADDRESS, '경기')
ORDER BY WAREHOUSE_ID ASC;