摘要： --sql写法： update bcd_samplingrecord_detail set Invalid=t.cin,hasfilter=t.ch from (select recordid cid,Invalid cin,hasfilter ch from bcd_samplingrecord) 阅读全文

摘要： declare newguid VARCHAR2(50); begin for c in (select * from bcd_samplingrecord where recordid is null) loop SELECT lower(SUBSTR(GUID,1,8))||'-'||lower 阅读全文