ITmembers.net 아카이브 · 2002–2009

질문과 답변

이거 문제가 머져.ㅠㅠ

SELECT nvl(REG_COMPANY_CD,' '), nvl(PROGRAM_CD,' '), nvl(SALE_TYPE_CD,' '), nvl(GET_SALETYPE(SALE_TYPE_CD ),' '), nvl(sale_type_name,' '), nvl( MEM_GRADE_CD,' '), nvl(PRICE_TYPE_CD,' '), nvl(GET_PRICENAME(PRICE_TYPE_CD),' '), nvl(price_type_name,' '), nvl(SEAT_GRADE_CD,' '), nvl(GET_GRADENAME(SEAT_GRADE_CD),' '), nvl(seat_grade_cd,' '), nvl(PRICE, ' ') FROM T_SCHEDULE_PRICE where reg_company_cd = '100005' and program_cd = '10000001' group by REG_COMPANY_CD,PROGRAM_CD,SALE_TYPE_CD,MEM_GRADE_CD,PRICE_TYPE_CD,SEAT_GRADE_CD,PRICE


nvl붙이려고 하는데;;;어디 잘못한거 같은데;;;

못찾겠어여.ㅠㅠ