oracle中decode函数，length函数,substr函数，upper函数,自己看的

最新推荐文章于 2022-03-01 09:58:31 发布

时光旅行者一号

最新推荐文章于 2022-03-01 09:58:31 发布

阅读量1.7k

点赞数

分类专栏： oracle

本文链接：https://blog.csdn.net/qq_30072293/article/details/52301130

版权

oracle 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

update uadpt_tac_act_data set TERMINAL=UPPER(TERMINAL)

update uadpt_tac_act_data set brand=substr(brand,1,50) where length(brand) > 50

update uadpt_tac_act_data set soft_lock=decode(soft_lock,'AB卡','1','联通解锁助手','2','联通解锁助手+电信卡','3','网络解锁助手','4','系统升级','5',NULL,'0',soft_lock)

update uadpt_tac_act_data set NETTYPE_UNI=decode(NETTYPE_UNI,'2g','2G','3g','3G','4g','4G',NULL,'N',NETTYPE_UNI)

update uadpt_tac_act_data set NETTYPE_OTH=UPPER(NETTYPE_OTH)

String sqltac = "update uadpt_tac_act_data set status_tac='1' where length(tac) = 8";
       // 终端类型
       String sqlterminal = "update uadpt_tac_act_data set status_terminal='1' where terminal in ('2G','3G','4G')";
       // 品牌
       String sqlbrand = "update uadpt_tac_act_data set status_brand='1' where length(brand) <= 50";
       // 型号
       String sqlmodel = "update uadpt_tac_act_data set status_model='1' where length(model) <= 50";
       // 是否支持本网
       String sqlcmType = "update uadpt_tac_act_data set status_cm_type='1' where cm_type in ('0','1')";
       // 双卡
       String sqldual = "update uadpt_tac_act_data set status_dual='1' where dual in ('0','1')";
       // 软解锁
       String sqlsoftLock = "update uadpt_tac_act_data set status_soft_lock='1' where soft_lock in ('0','1','2','3','4','5')";
       //本网最高网终类型
       String sqlnettypeUni = "update uadpt_tac_act_data set status_nettype_uni='1' where nettype_uni in ('2G','3G','4G','N')";
       //异网最高网终类型
       String sqlnettypeOth = "update uadpt_tac_act_data set status_nettype_oth='1' where nettype_oth in ('2G','3G','4G')";