摘要：
--sql写法： update bcd_samplingrecord_detail set Invalid=t.cin,hasfilter=t.ch from (select recordid cid,Invalid cin,hasfilter ch from bcd_samplingrecord) 阅读全文
posted @ 2022-01-18 19:06
vinsonLu
阅读(2080)
评论(0)
推荐(0)
摘要：
declare newguid VARCHAR2(50); begin for c in (select * from bcd_samplingrecord where recordid is null) loop SELECT lower(SUBSTR(GUID,1,8))||'-'||lower 阅读全文
posted @ 2022-01-18 19:05
vinsonLu
阅读(84)
评论(0)
推荐(0)
浙公网安备 33010602011771号