Oracle # 字符串匹配函数（Oracle、SQLSERVER、Excel）

今天药忘吃喽~ 2022-02-26 05:44 620阅读 0赞

**引言：**

当数据库设置字段的时候，会设置1表XXX；0表示XXX。查询的时候怎么显示汉字呢？

--------------------

**Oracle数据库：**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE2MzEzNTc1_size_16_color_FFFFFF_t_70][]

普通查询数据：

select \* from U\_ORANGEZATION

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE2MzEzNTc1_size_16_color_FFFFFF_t_70 1][]

匹配查询数据：

select   
ORG\_ID,ORG\_NAME,PARENT\_ORD\_ID,CREATE\_TIME,CREATE\_USERCODE,  
CREATE\_USERANME,MOFDIFY\_TIME,MODIFY\_USERCODE,MODIFY\_USERNAME,  
decode(DATA\_STATE,0,'禁用'，1,'启用')  as DATA\_STATE  
from U\_ORANGEZATION

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE2MzEzNTc1_size_16_color_FFFFFF_t_70 2][]

--------------------

**Sql Server 数据库：**

普通查询数据：

SELECT  
 dbo.tb\_GoodsInfo.GoodsID,dbo.tb\_GoodsInfo.GoodsTypeID,dbo.tb\_GoodsInfo.GoodsName,dbo.tb\_GoodsInfo.GoodsIntroduce,dbo.tb\_GoodsInfo.GoodsPrice,dbo.tb\_GoodsInfo.GoodsPhoto,dbo.tb\_GoodsInfo.GoodsDate,dbo.tb\_GoodsInfo.GoodsIsNew  
FROM  
dbo.tb\_GoodsInfo

![20190329103610471.png][]

匹配查询数据：

select  
case when dbo.tb\_GoodsInfo.GoodsID=1 then'男' when dbo.tb\_GoodsInfo.GoodsID=100 then '女' end as GoodsID  
from dbo.tb\_GoodsInfo

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE2MzEzNTc1_size_16_color_FFFFFF_t_70 3][]

--------------------

Excel：

3个字段：

=if(A1=1,"未完成"，if(A1="","完成","其他"))

2个字段：  
＝if(A1=1,"未完成",“已完成")

--------------------

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE2MzEzNTc1_size_16_color_FFFFFF_t_70]: /images/20220226/168cdf6e123b4fd998a0c566420f5f7c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE2MzEzNTc1_size_16_color_FFFFFF_t_70 1]: /images/20220226/e7eb4d2112874f3c94d96b7656c1ecd9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE2MzEzNTc1_size_16_color_FFFFFF_t_70 2]: /images/20220226/cbd0b704f0774a81803f68bc4a6bebab.png
[20190329103610471.png]: /images/20220226/f08d728e489b4d1fa86a758351bc8a82.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE2MzEzNTc1_size_16_color_FFFFFF_t_70 3]: /images/20220226/2c90a73ddbe146d18d1c3c82d256f6a7.png