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붙이려고 하는데;;;어디 잘못한거 같은데;;;
못찾겠어여.ㅠㅠ
|
