SELECT   CASE WHEN EXISTS  (SELECT 1
                            FROM GOODS
                            WHERE GOODS_CD='0000000000001' ) THEN 1 ELSE 0 END AS AA
       , CASE WHEN EXISTS (SELECT 1
                            FROM GOODS
                            WHERE GOODS_CD='000000000000A') THEN 1 ELSE 0 END AS AB  

FROM DUAL;

case exist 쓴 구문인데 잘 모르겠네요;;

아시는분 설명좀 부탁드려요~