Example of writing SQL instead of cursor

Time:2021-10-18
Update Tb_Garden1 G Set Steward = (
Select Id From Zyq.Tb_ User u where replace (u.name, 'zone') = g.name and rownum = 1)
Where exists (select 1 from ZYQ. Tb_user u where replace (u.name, 'zone') = g.name and rownum = 1)

Recommended Today

Swift advanced (XV) extension

The extension in swift is somewhat similar to the category in OC Extension can beenumeration、structural morphology、class、agreementAdd new features□ you can add methods, calculation attributes, subscripts, (convenient) initializers, nested types, protocols, etc What extensions can’t do:□ original functions cannot be overwritten□ you cannot add storage attributes or add attribute observers to existing attributes□ cannot add parent […]