Ò»¸ö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
Ïà¹ØÎÊ´ð£º
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó #topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬ Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04 #lslv -l lv04
......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
²é¿´ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁ MySQLʹÓõÄÊÇselect @@tx_isolation; ÔÚOracleÖв鿴ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁîÊÇÄĸö£¿ SQL code: SELECT /*+ rule */ s.username,decode(l.type,'TM','TABLE LOCK','TX','ROW LOCK', ......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......