摘要:
--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
阅读(2006)
推荐(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
阅读(77)
推荐(0)
编辑