OGG-字段符合特定条件，转换为某些特定字符，测试

SQL> desc test1
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ID                                                 NUMBER(38)
 NAME                                               VARCHAR2(10)
SQL> insert into test1(id) values(7);
SQL> insert into test1 values(8,null);
SQL> insert into test1 values(9,1);
SQL> insert into test1 values(10,‘1‘);
SQL> insert into test1 values(11,‘0‘);

map test2.test1, target test2.test1,COLMAP(usedefaults,NAME=@EVAL(NAME=‘1‘,‘0‘,NAME=‘0‘,‘1‘,‘1‘));
        ID NAME
---------- ----------
         7 1
         8 1
         9 0
        10 0
        11 1
        
map test2.test1, target test2.test1,COLMAP(usedefaults,NAME=@EVAL(NAME=‘1‘,‘0‘,NAME=‘0‘,‘1‘,‘1‘));

map test2.test1, target test2.test1,COLMAP(usedefaults,NAME=@case(NAME,‘1‘,‘0‘,‘0‘,‘1‘,‘1‘));
SQL> insert into test1(id) values(12);
SQL> insert into test1 values(13,null);
SQL> insert into test1 values(14,‘1‘);
SQL> insert into test1 values(15,‘0‘);
        12 1
        13 1
        14 0
        15 1