CREATE TABLE "TEST"
( "VALUE" VARCHAR2(255)
);
INSERT INTO "VICEL"."TEST"("VALUE") VALUES ('1');
INSERT INTO "VICEL"."TEST"("VALUE") VALUES ('2');
INSERT INTO "VICEL"."TEST"("VALUE") VALUES ('3');
INSERT INTO "VICEL"."TEST"("VALUE") VALUES ('4');
SELECT
decode( VALUE, '1', '国内销售', '2', '外贸销售', '3', '期初销售', '其他' ) ORDER_TYPE
FROM
TEST;
