Ò»Ìõ 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ʵÏÖµÄ.
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔص½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......