????Oracle????????????????? д????洢?????????????????????????????ò?????????????????????磬????????????·?????????ū???????????????
????Oracle???????????????
????1.??β????????????????????????????
????2.??β?????????????????????????????ж??????????????????????????????????????
????3.?????????????????????????????????????????????????????????????
????selectto_char('aaa')fromdual;
????select''|| to_char('aaa') ||''fromdual;
????select''''|| to_char('aaa') ||''''fromdual;
????select''''''|| to_char('aaa') ||''''''fromdual;
????select''''''''|| to_char('aaa') ||''''''''fromdual;
????select' '' '||' '||' '' '|| to_char('aaa') ||' '' '' 'fromdual;
????Oracle?????????????????? ROW_NUMBER() OVER (PARTITION BY a.orgunit?? a.billcode ORDER BY a.invalidtime desc) AS RN
????FROM am_card a
????where a.orgunit = (select recid from md_org where stdcode = srcunitcode)
????and a.billcode in ('''' || replace(srccardbillcodes?? '??' ?? '''??''') || ''''))
????WHERE RN = 1);
????begin
????DBMS_OUTPUT.PUT_LINE('???:');
????for srccard in c_srccard loop --?????Щ???????μ??????汾????
????dstcardrecid := sys_guid();
????DBMS_OUTPUT.PUT_LINE(srccard.recid || srccard.billcode || dstcardrecid ||';');
????end loop;
????end;
????call proc_createnewcardversion('010101'??'4701-0001??4701-0002');