SQL> select * from t_test_12;

                                 TYPEID TYPENAME
--------------------------------------- --------------------------------------------------------------------------------
                                      1 zxy1
                                      2 zxy2

SQL> select (case when typeid=1 then (select 'zxy1' from dual)
2 when typeid=2 then (select 'zxy2' from dual)
3 end)
4 from t_test_12
5 /

(CASEWHENTYPEID=1THEN(SELECT'Z
------------------------------
zxy1
zxy2

小结：１，case when ,when可以是复杂的sql组合，then也可以是复杂的sql组合

ITPub博客

sql中case when的小学

最新文章