Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Êý¾Ý¿â »º³å³Ø - Oracle / »ù´¡ºÍ¹ÜÀí

ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£

²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿

ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ

ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

oracle °²×° 01092 ´íÎó - Oracle / »ù´¡ºÍ¹ÜÀí

oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log 
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......

oracle´¥·¢Æ÷²åÈëÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

ÎÒÓÐÁ½¸ö±í£¨A±íºÍB±í£©£¬»ú¹¹ÍêÈ«Ïàͬ£ºA ±í½¨Á¢´¥·¢Æ÷
µ±insert into A(id,name) values('1','zhangsan'); ÎÒÖ»Ï뽫name=zhangsanµÄʱºò½«insertÓï¾ä²åÈëµ½B±íÖжøA±í²»Ö´ÐвÙ×÷Õâ¸ö´¥·¢Æ÷Ó¦¸ÃÔõôʵÏÖÄØ£¿
È磺 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ