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 ÊÇÒ»¸öδ±»¶¨
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
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 ×Ö¶ ......
SQLServerºÍOracleÊÇ´ó¼Ò¾³£Óõ½µÄÊý¾Ý¿â£¬Ôڴ˸Ðл×÷Õß×ܽá³öÕâЩ³£Óú¯ÊýÒÔ¹©´ó¼Ò²Î¿¼¡£
Êýѧº¯Êý£º
¡¡1.¾ø¶ÔÖµ
¡¡¡¡ S:SELECT abs(-1) value
¡¡¡¡ O:SELECT abs(-1) value from dual
2.È¡Õû(´ó)
¡¡¡¡ S:SELECT ceiling(-1.001) value
¡¡¡¡ O:SELECT ceil(-1.001) value from dual
3.È¡Õû£¨Ð¡£© ......
1. ˵Ã÷£º¸´ÖƱí(Ö»¸´Öƽṹ£¬Ô´±íÃû£ºa£¬Ð±íÃû£ºb)
SQL: select * into b from a where 1<>1;
2. ˵Ã÷£º¿½±´±í(¿½±´Êý¾Ý£¬Ô´±íÃû£ºa£¬Ä¿±ê±íÃû£ºb)
SQL: insert into b(a, b, c) select d, e, f from b;
&nb ......