ORACLE sql insert case when

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

原文地址:https://www.cnblogs.com/yr1126/p/15719412.html