Oracle functionµ÷Óô洢¹ý³Ì - Oracle / »ù´¡ºÍ¹ÜÀí
function Ö±½Óµ÷ÓÃÒ»¸ö´æ´¢¹ý³Ì£¬ ²»ÐèÒª´«µÝ²ÎÊý£¬Ò²ÎÞ·µ»ØÖµ£¬Ôõôд£¿
³õѧ£¬¶àл£¡
´æ´¢¹ý³Ìµ÷Óú¯ÊýÂð£¿
º¯ÊýÓë´æ´¢¹ý³ÌµÄµ÷Ó÷½Ê½£º
µ÷Óô洢¹ý³Ì±ØÐëÒÔÓï¾ä·½Ê½
begin
proc;--Õû¸öÊÇÒ»¸öÓï¾ä
end;
º¯ÊýµÄµ÷Ó÷½Ê½Îª±í´ïʽ
begin
i := func();--func();--func()Ϊһ¸ö±í´ïʽ
end;
ºÃµÄ£¬Ñ§Ï°ÁË¡£
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......
ÔÚÁ¬½ÓÊý¾ÝԴʱ£¬Êý¾ÝÁ¬½ÓÊôÐÔÖÐÑ¡Ôñoracle provider for ole db
µ¥»÷ÏÂÒ»²½Ê±±¨´í ¡°Ìṩ³ÌÐò²»ÔÙ¿ÉÓã¬ÇëÈ·¶¨Ìṩ³ÌÐò±»ÕýÈ·°²×°¡£¡±
ÎÒÓõÄÊÇoracle 8£¬ÏÈǰÓõÄ10gÒ²Óöµ½ÀàËÆµÄÎÊÌâ
ʹÓÃmicrosoft ole db pro ......