oracle case when 缺失等号
时间: 2023-10-20 12:34:35 浏览: 91
Oracle 技巧
在Oracle的CASE WHEN语法中,缺失等号是不合法的。CASE WHEN语法的基本结构是:
CASE search_expression
WHEN expression1 THEN result1
WHEN expression2 THEN result2
...
ELSE default_result
END
在每个WHEN子句中,需要使用等号来判断search_expression和expression的关系。例如:WHEN t.vc_state = '2' THEN t.vc_userId表示当t.vc_state等于'2'时,将t.vc_userId作为结果返回。所以在CASE WHEN语法中,等号是必不可少的。 <span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* [Oracle之case when用法](https://blog.csdn.net/qzz12345/article/details/124650481)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 33.333333333333336%"]
- *2* [oracle 在where条件中写case when](https://blog.csdn.net/zhu_nana/article/details/79626104)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 33.333333333333336%"]
- *3* [SQL培训第一期](https://download.csdn.net/download/lv_soso/10286227)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 33.333333333333336%"]
[ .reference_list ]
阅读全文