ORACLE sql insert case when

INSERT INTO "TEST1"."TEST" ( "id", "name" )
VALUES
( '10', (case '1' when '1' then 'yes' when '0' then 'no' end) );

posted on 2021-12-30 10:37  yr1126  阅读(414)  评论(0编辑  收藏  举报