Ò»Ìõ SQL - Oracle / »ù´¡ºÍ¹ÜÀí
ÓÐÕâÑùÒ»ÌõSQL
Select Get_Costtaxrate(col1), Get_Tcostvalue(col1) from a
ÆäÖÐGet_Costtaxrate¡¢Get_Tcostvalue¶¼ÊǺ¯Êý£¬ÕâÁ½¸öº¯ÊýÀïÃ涼ÊDzéÕÒÒ»¸ö´ó±í£¬Get_Tcostvalue»¹ÐèÒªµ÷ÓÃGet_Costtaxrate
À´½øÐмÆË㣬¿ÉÒÔ½«Á½¸öº¯ÊýºÏ²¢³ÉÒ»¸öº¯ÊýÂð£¿
»òÕßÓÐûÓиßЧһµãµÄ·½Ê½£¬¸Ð¾õÕâÑùЧÂʲ»¸ß
¸ø³öÄãµÄ±í½á¹¹£¬Êý¾ÝºÍÏëÒªµÄ½á¹û¡£
2¸öº¯ÊýºÏ²¢,Òª¿´ÄãµÄº¯ÊýÀï°üº¬µÄÂß¼¹ØϵÁË,¸´ÔӵĻ°½¨ÒéÄ㻹µÄÓÃ2¸öº¯Êý
׼ȷÀ´ËµÓ¦¸ÃÊÇÈý¸öº¯Êý£¬
Function A(out p1,out p2)
Function B
µ÷ÓÃ A
·µ»Ø P1
Function C
µ÷ÓÃ A
·µ»Ø P1ÓëP2µÄ¼ÆËãÖµ
ÒªÊÇÄܹ»ÔÚselect ÀïÈ¡µÃº¯ÊýµÄÁ½¸ö·µ»ØÖµ¾ÍºÃÁË
ÎҾͿÉÒÔÕâÑùд
select P1,P1ÓëP2µÄÔËËã
from
(
select A(P1,P2) from Tab1
)
²»ÖªµÀ¿ÉÒÔÕâÑù×ö²»
ÄãÕâ¸öÓï¾äÎÒ²»ÖªµÀ¿ÉÐв»£¬µ«Ë¼Â·ÍêÈ«¿ÉÒÔ°¡¡£PLSQLÀïÍêÈ«¿ÉÒÔ¸³Öµ¸ø±äÁ¿Âï
¿ÉÒԺϲ¢,Äã¼Ó¸ö²ÎÊý,Function A(out p1,out p2, arg In varchar2)
µ±arg ÊÇ'B'µÄʱºò·µ»ØÈ¡P1,ÊÇ'C'µÄʱºò ·µ»ØP2=P1ÓëP2µÄ¼ÆËã
Ê×ÏÈ£¬²»ÊÇÔÚPl/SQLÀ¶øÊÇÒ»ÌõSQLÀïÃ棬ËùÒÔ²»ÄÜ¿¼ÂǸ³Öµ±äÁ¿µÄ·½Ê½
Æä´Î£¬ÏÖÔÚ²»ÊǺϲ¢Óë·ñµÄÎÊÌ⣬¶øÊÇÏ£Íû¼õÉÙµ÷ÓÃ2´ÎA º¯ÊýµÄÓ°Ïì¡£
ûÓд𰸣¿
Õâ¸öÒ²Äܺϲ¢°¡?²»»á°É..
µ«ÊǺ¯ÊýÖ»ÄÜ·µ»ØÒ»¸öÊýÖµ°¡.
²»ÄÜÔÚSQLʵÏÖµÄ.
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP
²Î¿¼:http://hi.baidu.com/toiota ......
ÎҵĴ¦ÀíÊÇÕâÑùµÄ£º
ÎÒÓÐÒ»¸öºÜ´óµÄÊý¾Ý¼¯ºÏ£¬´¦ÓÚÐÔÄÜ·½ÃæµÄ¿¼ÂÇÐèҪʹÓÃÁÙʱ±í¹ý¶É£¬²¢ÇÒʹÓ÷ÖÒ³µÄ·½Ê½ÏòÁÙʱ±íÖвåÈëÊý¾Ý£¬Êý¾ÝʹÓÃÍê±Ïºó£¬É¾³ýÁÙʱ±íµÄÊý¾Ý¡£
³öÏÖµÄÏÖÏ󣺵±OracleÖØÐÂÆô¶¯ºó£¬µÚÒ»Ò³²åÈëµÄ ......