update dev_file set size_info = '100MB' where storage_path = '手动阀发射点发顺丰/s/adasfd'
storage_path是nclob数据类型
既然数据类型不一致无法匹配,那我就把数据类型弄成一样的,把nclob转成char再进行匹配
select * from dev_file WHERE to_char(storage_path) = 'asdfasdff/adfadf/adfa;
这样就ok了
update dev_file set size_info = '100MB' where storage_path = '手动阀发射点发顺丰/s/adasfd'
storage_path是nclob数据类型
既然数据类型不一致无法匹配,那我就把数据类型弄成一样的,把nclob转成char再进行匹配
select * from dev_file WHERE to_char(storage_path) = 'asdfasdff/adfadf/adfa;
这样就ok了