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.
13 lines
404 B
SQL
13 lines
404 B
SQL
|
|
|
|
-- 토요일 정액권 추가
|
|
|
|
INSERT INTO DAY_ADJUST_INFO
|
|
(FARE_OFFICE_ID, BOOTH_ID, YEAR, MONTH, DAY, WEEKDAY_KBN, IN_COUPON_SALE_QUANTITY, IN_COUPON_SALE, IN_K_COUPON_SALE_Q, IN_K_COUPON_SALE_INCOME, CREATE_DATE, CREATER, UPDATE_DATE, UPDATER)
|
|
VALUES
|
|
('01', '01', '2019', '03', '02', '2', 1, 1000, 2, 2000, SYSDATE, 'TEST', SYSDATE, 'TEST')
|
|
;
|
|
|
|
--delete from DAY_ADJUST_INFO where creater = 'TEST';
|
|
|