Ò»¸öoracleµÄUPDATEÓï¾äÇó½Ì~
Start_Time (DateTime ÀàÐÍ) 3/4/0010 AM 05:29:58 3/4/0010 AM 10:21:33 3/4/0010 PM 02:47:12 3/4/0010 PM 07:14:58 3/4/0010 PM 11:40:35 3/5/0010 AM 04:14:42 3/5/0010 AM 08:41:08 3/5/0010 PM 01:09:13 3/5/0010 PM 05:39:01 3/9/0010 AM 04:04:39 3/3/0010 AM 02:12:52 3/3/0010 AM 08:21:53 3/3/0010 PM 01:11:07 3/3/0010 PM 05:59:52 ÕâÅúÊý¾ÝÒª½« 0010 ¸Ä³É 2010Ôõô¸Ä£¿ SQL code: update wafer_sort_lot set start_time = replace(start_time,'([0-9]{1,2}/[0-9]{1,2}/)(0010)(.*)','\12010\3') ÕâÑùдµÄ»° Ö±½Ó¸Ä³ÉÁË 3/4/2010 ºóÃæµÄʱ ·Ö ÃëûÁË Çó½Ì лÁË
ÓÃreplace¿ÉÒÔÂð Ŷ£¬ÊÇdatetimeÀàÐÍ£¬²»ÄÜreplace£¬oracleµÄÖ»ÄܰﶥÁË ½¨ÒéÈ¥ORACLE°æÎÊÏÂ..ÒýÓà ½¨ÒéÈ¥ORACLE°æÎÊÏÂ.. Ä㻹²»ºÃºÃѧϰ£¿ÒýÓà Ŷ£¬ÊÇdatetimeÀàÐÍ£¬²»ÄÜreplace£¬oracleµÄÖ»ÄܰﶥÁËÒýÓà ½¨ÒéÈ¥ORACLE°æÎÊÏÂ.. Õâ¸ö¾ÍÊÇ´Ó Oracle ÄDZ߰á¹ýÀ´µÄ - - û»ØÓ¦¡£¡£¡£ SQL code: update tb set Start_Time=add_months(Start_Time,-2000*12) SQL code Code highl
Ïà¹ØÎÊ´ð£º
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨ ÒýÓà °²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ emp_no emp_name ------- ------------ 0001 TOM 0002 JOHN 0003 MARY ³£Óõ绰 ¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput) 0001,TOM 0002,JOHN
......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
Õâ¸öSQLÓï¾äÔõôд? ÏÖÔÚÓÐÒ»¸ö±íT,ÀïÃæ¾Í3¸ö×ֶΠѧÉúID(sid)¿Î³Ì(cName)³É¼¨(score) 1 1 75 2 2 90 3 2 60 4 3 89 5 3 80 6 3 70 ÎÒÏÖÔÚÏëÖªµÀµÃµ½µÄ½á¹ûÊÇ:ÿÃſγÌÅÅÔÚǰÁ½ÃûµÄѧÉúµÄID,Ó¦¸ÃÔõÃ´Ð´ÄØ?
......