oracle 多表更新,游标定义语句.
F_ID F_BILLID F_SOURCEITEMID F_LOT F_PRODUCTDATE F_EXPIRATIONDATE ------------- ---------------- -------------- -------------------- ------------- ----------------20000297 20000345 20000306 2 2010-04-02 2010-05-01
20000298 20000345 20000306 3 2010-04-03 2010-05-02
20000299 20000345 20000307 3 2010-04-04 2010-05-03
20000300 20000346 20000308 1 2010-04-05 2010-05-04
20000302 20000346 20000308 1 2010-04-07 2010-05-05
20000304 20000346 20000309 2 2010-04-07 2010-05-06
20000305 20000346 20000309 3 2010-04-08 2010-05-07
20000307 20000346 20000310 3 2010-04-09 2010-05-08
20000308 20000346 20000310 4 2010-04-10 2010-05-09
20000309 20000348 20000311 1 2010-04-12 2010-05-10
20000310 20000348 20000312 2 2010-04-12 2010-05-11
20000311 20000348 20000313 4 2010-04-13 2010-05-12
20000312 20000350 20000315 1 2010-04-14 2010-05-13
20000313 20000350 20000316 2 2010-04-15 2010-05-14
20000314 20000350 20000317 3 2010-04-16 2010-05-15
20000291 20000343 20000302 1 2010-04-17 2010-05-16
20000292 20000343 20000302 2 2010-04-18 2010-05-17
20000293 20000343 20000303 2 2010-04-19 2010-05-18
20000294 20000343 20000304 3 2010-04-20 2010-05-19
20000296 20000345 20000305 1 2010-04-21 2010-05-20
页:
[1]