Oracle:pl/sql Òì³£´¦Àí[ת]
pl/sql ÌṩÁËÇ¿´ó¶øÁé»îµÄÊÖ¶ÎÀ´²¶×½ºÍ´¦Àí³ÌÐò²úÉúµÄÒì³££¬´Ó¶øÊ¹ oracle µÄÓû§Ô¶ÀëһЩÁîÈË·³ÄÕµÄ bug ¡£
pl/sql Òì³£´¦ÀíµÄ¸ÅÄîºÍÊõÓï
ÔÚ oracle ÖÐËùÓеĴíÎó¶¼±»ÈÏΪÊDz»Ó¦¸Ã·¢ÉúµÄÒì³£¡£Ò»¸öÒì³£¿ÉÄÜÊÇÒÔÏ 3 ÖÖÇé¿öµÄÒ»ÖÖ£º
u ÓÉϵͳ²úÉúµÄ´íÎ󣨓 out of memory ”»ò“ duplicate value in index ”£©
u Óû§ÐÐΪµ¼ÖµĴíÎó
u Ó¦ÓóÌÐò¸øÓû§µÄÒ»¸ö¾¯¸æ
pl/sql ÓÃÒ»ÖÖÒì³£¾ä±úµÄ½á¹¹À´²¶×½ºÍÏìÓ¦´íÎó¡£ÕýÊÇÓÐÁËÒì³£¾ä±úµÄ´æÔÚ£¬ÎÒÃÇÄܷܺ½±ãµÄ·ÖÀëÒì³£´¦Àí´úÂëÓë¿ÉÖ´ÐдúÂë¡£ÓëÏßÐԵĴúÂëÏà±È£¬ÎªÁË´¦ÀíÒì³££¬Òì³£¾ä±úÌṩÁËÒ»ÖÖÀàËÆÊ¼þÇý¶¯µÄģʽ£»»»¾ä»°Ëµ£¬¾ÍÊDz»¹ÜÒ»ÖÖÌØ¶¨µÄ´íÎóÔÚºÎʱºÎµØ·¢Éú£¬Ëü¶¼½«±»Í¬Ò»¸ö´úÂë´¦Àí¡£
µ±Ò»¸ö´íÎó³öÏÖºó£¬ÎÞÂÛËüÊÇϵͳ»¹ÊdzÌÐò²úÉúµÄ£¬¶¼½«µ¼ÖÂÒ»¸öÒì³£¡£Ö®ºó£¬¿ÉÖ´ÐгÌÐò±»Öжϣ¬¿ØÖÆÈ¨×ªÒƸøÒì³£´¦Àí´úÂë¡£´¦ÀíÍêÒì³£ºó£¬³ÌÐò½«²»»á»Øµ½ÏÈǰ±»ÖжϵÄλÖã¬Ïà·´µÄ£¬¿ØÖÆÈ¨±»½»¸øÁ˵±Ç°³ÌÐòµÄÍâΧģ¿é£¨¿ÉÄÜÊdzÌÐò£¬Ò²¿ÉÄÜÊÇϵͳ£©¡£
procedure jimmy
is
new_value varchar(35)
begin
|--------new_value:=old_value || ‘-new’;
| if new_value like ‘like%’
| then
| …..
| end if;
| exception
|----- à when value_error
then
…..
end;
ÒòΪ old_value ÊÇÒ»¸öδ±»¶¨
Ïà¹ØÎĵµ£º
´ò¿ª²éѯ·ÖÎöÆ÷£¬ÊäÈëÃüÁî¼´¿É¡£ DUMP TRANSACTION Êý¾Ý¿âÃû WITH NO_LOG
Èç¹û¾õµÃ·¢ÏÖLDFÎļþÕ¼ÓôÅÅ̿ռ仹ÊǺܴó¡£
Çë´ò¿ªÆóÒµ¹ÜÀíÆ÷--ÓÒ¼üµã»÷ÐèѹËõµÄÊý¾Ý¿â--ËùÓÐÈÎÎñ--ÊÕËõÊý¾Ý¿â--ÊÕËõÎļþ--Ñ¡ÔñÈÕÖ¾Îļþ--ÔÚÊÕËõ·½Ê½ÀïÑ¡ÔñÊÕËõÖÁXXM,ÕâÀï»á¸ø³öÒ»¸öÔÊÐíÊÕËõµ½µÄ×îСMÊý,µ÷ÕûÈ·¶¨¼´¿É¡£
Technorati ±êÇ©: SQL ......
http://blog.csdn.net/iamstillzhang/archive/2007/04/01/1548377.aspx
ÓÃmysqlÔ´Âë½øÐÐSQL½âÎö
MysqlÊÇͨ¹ýyacc½øÐÐSQLÓï¾ä½âÎöµÄ£¬ÕâÀï½éÉÜÒ»ÏÂÈçºÎʹÓÃmysqlµÄÔ´Âë½øÐÐSQLÓï¾ä½âÎö¡£ÓÉÓÚMysqlµÄÔ´´úÂë×¢ÊͱȽÏÉÙ£¬¶øÇÒȱÉÙ×ÊÁÏ£¬ËùÓÐЩµØ·½Ñо¿²»¹»ÉîÈë¡£
1 Filed½éÉÜ
MY ......
ʹÓùý Access µÄÅóÓѶ¼ÖªµÀ£¬Access ÀïÓиö“ÊÇ/·ñ”Êý¾ÝÀàÐÍ£¬ÔÚ SQL Server ÖУ¬Ã»ÓÐÕâ¸öÃû³Æ£¬¶øÊ¹Óà bit¡£ÔÚʹÓùý³ÌÖÐÓм¸µãÐèҪעÒâµÄ£º
£±¡¢bit Óë SQL Server µÄÕûÐͺÍÊý×ÖÊý¾ÝÏàËÆµÄÊý×ÖÊý¾Ý£¬µ« bit ÁÐÖ»ÄÜ´æ´¢ 0 ºÍ 1¡£
£²¡¢ÔÚ²åÈë¡¢ÐÞ¸Ä bit Êý¾Ýʱ£¬Ê¹Óà 0 »ò 1 £¬¶ø²»ÊÇ false »ò true£¬bit ×Ö¶ ......
update CHELIANG_MINGDAN set clmd_yunxuzaizhong = cast(clmd_yunxuzaizhong/1000 as decimal(14,4)) where clmd_yunxuzaizhong is not null
update CHELIANG_MINGDAN set clmd_carweight = cast(clmd_carweight/1000 as decimal(14,4)) where clmd_carweight is not null ......