oracleÖÐupdate´¥·¢Æ÷
±í TB_DAGL_LOCATINDEX ½á¹¹
´æ·ÅλÖã¨store_location£© ʹÓó¤¶È £¨SHELVING_LEN£©CM Ö÷¼üid£¨ÎÞÒâÒ壩
5B-029-001 20 1
5B-029-001 30 2
5B-029-002 15 5
±í TB_JS_STOREROOM_DETAILSIZE ½á¹¹
´æ·ÅλÖã¨KFH_DESCRIBLE£© ʹÓó¤¶È £¨USE_LEN£©CM Ö÷¼üid£¨ÎÞÒâÒ壩
5B-029-001 50 113
5B-029-002 15 1112
ÏëʵÏÖTB_DAGL_LOCATINDEX ±íÖÐ×ֶΡ°store_location¡±Ð޸ĺó£¬Ïà¶ÔÓ¦µÄSHELVING_LENµÄsumÖ
Ïà¹ØÎÊ´ð£º
delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×Ö¶Î
http://blog.csdn.net/zxf_feng/archive/2008/12/21/3571961.aspx
¿´¿´Õâ¸ö
ÒýÓÃ
vStream := TMemorySt ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
......
ÐÖµÜ Í¼¹ÒÁË¡£
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value ......
±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
set A.flag=1
where A.id in (select B.id from table_b B)
½á¹ûÎóд³É
update table_a A
set A.flag=1
where ......
ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ
DB2ÖÐÈçºÎʹÓÃÐ ......