You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
20 lines
457 B
SQL
20 lines
457 B
SQL
|
|
/*
|
|
요금단말정보에서 RFID구분에 따른 분류
|
|
- FARE_TERMINAL_INFO 의 RFID_KBN 은 01,03,04,99 만 rfid 금액으로 분류함
|
|
*/
|
|
CREATE OR REPLACE FUNCTION FUN_IS_RFID
|
|
(
|
|
in_rfid_kbn IN CHAR -- RFID 구분
|
|
) RETURN CHAR
|
|
IS
|
|
p_rfid_flag CHAR(1); -- 0:rfid금액제외, 1:rfid금액포함
|
|
BEGIN
|
|
SELECT DECODE(in_rfid_kbn, '01', '1', '03', '1', '04', '1', '99', '1', '0')
|
|
INTO p_rfid_flag
|
|
FROM DUAL;
|
|
|
|
RETURN p_rfid_flag;
|
|
END;
|
|
/
|