Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Ò»¸ö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Óëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

OracleµÄblob×Ö¶ÎÎÊÌâ - Oracle / ¿ª·¢

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......

Çë½ÌOracleÊÂÎñ¸ôÀë¼¶±ðÎÊÌâ - Oracle / ·Ç¼¼ÊõÇø

²é¿´ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁ
MySQLʹÓõÄÊÇselect @@tx_isolation;
ÔÚOracleÖв鿴ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁîÊÇÄĸö£¿

SQL code:

SELECT /*+ rule */ s.username,decode(l.type,'TM','TABLE LOCK','TX','ROW LOCK', ......

oracleµÄ°²×°ºÍʹÓúÃÄѰ¡ - Java / Java EE

oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿Ô­À´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ