| 澶辨晥閾炬帴澶勭悊 |
|
浼佷笟鏁版嵁搴撹繍钀ョ淮鎶ら渶瑕佺殑鍩烘湰璇彞 PDF 涓嬭澆
鏈珯鏁寸悊涓嬭澆錛?/strong>
閾炬帴錛?a target="_blank">https://pan.baidu.com/s/1vcAiCr41RJIIvLKVGgHvWg
鎻愬彇鐮侊細(xì)eltl
鐩稿叧鎴浘錛?/strong>
涓昏鍐呭錛?/strong>
1銆佹父鏍?/div>
v_rowid := '';
v_sql := 'SELECT xx From table_name a, table_name b
Where a.subsid = b.subsid order By a.rowid';
open v_cursor for v_sql; loop fetch v_cursor into v_rowid, v_prodid; if not v_cursor%found then exit ; end if ;
v_sql := 'UPDATE table_name a SET a.xx= :v_prodid WHERE a.rowid = :v_rowid';
EXECUTE IMMEDIATE v_sql using v_prodid, v_rowid;
COMMIT;
end loop; --緇撴潫寰幆
close v_cursor;--鍏抽棴娓告爣
姝ｅ垯琛ㄨ揪寮忓墧闄ら潪鏁板€煎瀷
regexp_replace(a.subsid, '[^0-9]');
涓€鑸眹鎬?/div>
Select nvl(瀛楁,’鍚堣’) 瀛楁鍚?
Sum/count --闇€瑕佺殑鍐呭
From table_name
Group by rollup((姹囨€誨瓧孌?);
|
| Java1234瀹樻柟緹?5錛?/td> | 
|
| Java1234瀹樻柟緹?5錛?/td> | 838462530 |
鑻忓叕緗戝畨澶?32061202001004鍙?/p>
