¼ÙÈçÎÒ´ÓÒ»¸öÊý¾Ý¿âÖе¼³ö10±íµÄÊý¾Ý£¬ÔÚ¼ÓÈëµ½ÎÒµÄÐÂÊý¾Ý¿âÖУ¬È»¶øÔÚÎÒµÄÊý¾Ý¿âÖÐûÓÐÏàÐŵıí½á¹¹ºÍ±í¿Õ¼ä£¬
ÇëÎÊoracle»á×Ô¶¯´´½¨±íµ¥¼äºÍ±í½á¹¹Â𣿠Èç¹û²»¿ÉÒÔÄÇÔõô°ì£¿
ÎÒÔÚoracle°æ¿éÖÐÒ²·¢ÁËͬһÎÊÌ⣬ ËÄܰïÎÒ120 ·Ö
ÔÚSQL ServerÀïÊÇ¿ÉÒԵġ£
Äã¿ÉÒÔ°Ñ10¸ö±íµÄddlÒ²µ¼³öÀ´£ ......
Ҫдһ¸öoracleµÄ×Ô¶¨Ò庯Êý,Íâ½ç´«ÈëÒ»¸öÈÕÆÚ,Ò»¸öÊýÖµ.·µ»ØÒ»¸öÊý×Ö
create or replace function f_test
(pdate in char,pctmoney in number)
return number
is
rsum number:=0;
begin
-- ÈÕÆÚСÓÚ2009-12-01 ·µ»ØÏµÊýÊÇ0.05 ·ñÔòϵÊýÊÇ0.025
......
ÐÂÊÖ£¬¸Õѧoracle.
ÎÒÔÚÃüÁîÐÐÖ´ÐÐeditÃüÁµ¯³ö±à¼Æ÷£¬ÊäÈë
select count(*) from test;
/
È»ºó¹Ø±Õ±à¼Æ÷£¬ÕâʱºòÃüÁîÐгöÏÖÁËÒ»¾ä
1* select count(*) from test;
È»ºó¾Íʲô¶¼Ã»ÓÐÁË£¬Ö´ÐеĽá¹ûÔõôµ÷³öÀ´£¿
¶ÔÁË ÎÒÓõÄÊÇoracle ex ¼ò»¯°æ£¬×¨ÃŸø¸öÈËʹÓõÄÃâ·Ñ°æ£¬
¸öÈË ......
±íµÄ×Ö¶ÎÃûÈçÏ£¬°üÀ¨8¸ö×ֶΣº
±àºÅ Ãû³Æ ³¤ ¿í ¸ß ±íÃæ»ý Ìå»ý ÖØÁ¿
1 abc 12 11 15 ¡£¡£ ¡£¡£ ¡£¡££¨Êý¾Ý¾ÙÀý£©
ÎÒ½¨ÁËÒ»¸öÈçϵĽṹµÄÒ»¸ö±í£¬±íÃèÊöµÄÊÇÒ»×鳤·½ÌåÎïÌåµÄÏà¹ØÊôÐÔÊý¾Ý£¬¾ßÌå×ֶζ¨Òå¼û±í¡£±íÖеÄÊý¾ÝÁ¿´ó¸ÅÔÚ5000ÍòÐÐ×óÓÒ£¬ÎÒ³£ÓõļìË÷Ó ......
ÎÒ²»ÖªµÀÊDz»ÊǸù¾Ýrowid´ÓСµ½´óµÄ˳Ðò²éÕÒ£¬²âÊÔ¹ý³ÌÊÇÕâÑù£º
Ò»¸ö±ítestÓжþÊ®ÍòÌõ¼Ç¼£¬ÆäÖÐ×Ö¶ÎAÊÇÖ÷¼ü£¬Öµ´Ó¡®1000001¡¯µ½¡®300000¡¯£¬
ÎÒ¸ù¾ÝrowidÅÅÐò£¬²é³örowid×îСµÄ¼Ç¼¶ÔÓ¦µÄAÊÇ¡®1000001¡¯£¬×î´óµÄ¼Ç¼¶ÔÓ¦µÄAÊÇ¡®300000¡¯£¬
È»ºóÎÒselect * from test where A like '%300000%' ,²éѯʱ ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------------------------------------------
Blog£º http://blog.csdn.net/tianlesoftware
ÍøÉÏ×ÊÔ´£º http://t ......