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

oracleÖÐ charºÍvarcharÀàÐͼæÈݵÄÎÊÌâ

  Çë½Ì¸÷λ¸ßÊÖ°ïæ£¡£¡
  ÔÚoracleÊý¾Ý¿âÖУ¬°ÑÒ»¸ö¿âÖбíµÄÄÚÈݵºµ½ÁíÒ»¿âµÄ±íÖУ¨Á½¸ö±íµÄ±íÃûÏàͬ£¬ÀïÃæµÄ×ֶζ¼Ò»Ñù£©£¬µ«ÊÇ×Ö¶ÎÀàÐͲ»Ïàͬ£¬Ò»¸öÊÇcharÀàÐÍ£¨³¤¶È10£©¡¢ÁíÒ»¸öÊÇvarcharÀàÐÍ£¨³¤¶È10£©¡£¾Ù¸öÀý×Ó˵һÏ£¬Èç¡®abc¡¯ÔÚcharÀàÐÍÖбíʾΪ¡®abc      ¡¯ÈçºÎÄÜʵÏÖÔÚ½« ¡®abc      ¡¯×ª»¯ÎªvarcharÀàÐÍʱ°Ñ¿Õ¸ñÈ¥µô°¡£¡

ÔÚµ¼Êý¾ÝµÄͬʱ»¹´¦ÀíÊý¾Ý,ÕæÃ»¸ã¹ý

Èç¹û¿ÉÒÔ²Ù×÷µÄ»°,¹Ø×¢....

selectµÄʱºòÔö¼Ótrimº¯Êý°¡

ÒýÓÃ
selectµÄʱºòÔö¼Ótrimº¯Êý°¡

2Â¥Õý½â

дsqlÓï¾äʱ£¬ÔÚҪȥ¿Õ¸ñµÄ×ֶκóÃæ¼Ótrim¾Í¿ÉÒÔÁË¡£


¹þ¹þ£¬Ð»Ð»¸÷룬µ«ÊÇÎÒµÄSqlÓï¾äÊÇ  select *  from table where  .....  Õâ¸öʱºò±íÖеÄ×Ö¶ÎÔõôÄܼÓÉÏtrimÄØ£¿ÎÒ²»¿ÉÄܰѱíÄÚµÄËùÓÐ×ֶζ¼ÄóöÀ´¼ÓÉÏtrimµÄ

Äǿ϶¨ÊÇûÓÐʲôºÃ°ì·¨

»òÕßÄã¿ÉÒÔÔÚinsert intoÖ®ºóÔÙÒ»´ÎÐÔÖ´ÐÐupdate newtable set varcharcol = trim(varcharcol);

ÒýÓÃ
Äǿ϶¨ÊÇûÓÐʲôºÃ°ì·¨

»òÕßÄã¿ÉÒÔÔÚinsert intoÖ®ºóÔÙÒ»´ÎÐÔÖ´ÐÐupdate newtable set varcharcol = trim(varcharcol);

лл£¬ÎÒÈ¥ÊÔÊÔ£¡


Ïà¹ØÎÊ´ð£º

oracleÊý¾Ý¿â »º³å³Ø - Oracle / »ù´¡ºÍ¹ÜÀí

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

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

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

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

oracle²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracle ......

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 / ......

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', ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ