Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

(ת)oracleºÍdb2Çø±ð

ÏîÄ¿ÖÐÒ»Ö±¶¼ÊÇÓÃdb2£¬ËùÒÔ¶Ôdb2Ò²ËãÓиöÒ»Öª°ë½â£¬¶ø¶ÔoracleÔòÊÇÖªÖ®ÉõÉÙ£¬Ò»Ö±¿àÓÚûÓлú»áÀ´Á·ÊÖ¡£×î½üÏîÄ¿×éÔÚ×ödb2µ½oracleµÄÇ¨ÒÆ£¬ÖÕÓÚ´þ×Å»ú»áÁË¡£½ñÌì¼òµ¥ËµÐ©ÔÚʵ¼ÊÏîÄ¿Óöµ½µÃһЩÎÊÌ⣬ÒÔºóÔÙÂýÂý²¹³ä¡£Í¬Ê±Ò²Ï£ÍûÈÊÈË־ʿ¶à¶àÖ¸µã¡£   
         ÓÉÓÚÕâÁ½Ìì¶¼ÊÇ×ö´æ´¢¹ý³ÌµÄÇ¨ÒÆ£¬ËùÒÔÕâÀïÖ÷Òª½²µ½µÄÊÇdb2ºÍoracleÁ½Õß´æ´¢¹ý³ÌÒÔ¼°Ò»Ð©ÏµÍ³º¯ÊýµÄÇø±ð¡£
     1¡¢´´½¨PROCEDUREµÄ²ÎÊýµÄÇø±ð
         1£©²ÎÊýÀàÐͺͲÎÊýÃû³ÆµÄλÖò»Í¬
             db2£º     CREATE PROCEDURE PRO1 (IN OrgID int)
             oracle£ºCREATE PROCEDURE PRO1 (OrgID IN int)
         2£©Í¬Ê±×÷ΪÊäÈëÊä³ö²ÎÊýµÄд·¨²»Í¬
             db2£º     CREATE PROCEDURE PRO1 (INOUT OrgID int)     INOUTÁ¬×Åд
             oracle£ºCREATE PROCEDURE PRO1 (OrgID IN OUT int)     IN OUTÖмä¿Õ¸ñ¸ô¿ª£¬¶øÇÒ±ØÐëINÔÚOUT֮ǰ
         3£©Ã»ÓÐÊäÈë»òÊä³ö²ÎÊýʱ
             db2£º     CREATE PROCEDURE PRO1 ()     
             oracle£ºCREATE PROCEDURE PRO1 ²»ÄÜÓпյÄÀ¨ºÅ
     2¡¢±äÁ¿¶¨ÒåºÍBEGIN ENDÌåµÄλÖò»Í¬
         db2ÖбäÁ¿¶¨ÒåÔÚBEGIN ENDÌåÄÚ£¬²¢ÇÒÿ¸ö±äÁ¿¶¼ÒªÓÃDECLAREÉùÃ÷£»´æ´¢¹ý³Ì½áÊøÊ±£¬ENDºó¸úP1£¬²¢ÇÒ²»ÐèÒª·ÖºÅ
         oracleÖбäÁ¿¶¨Ò屨ÐëÔÚBEGIN ENDÌåÍ⣬±äÁ¿¶¼²»ÐèÒªÓÃDECLAREÉùÃ÷(ÓÐÖÖ˵·¨ÊÇ£¬µÚÒ»¸ö±äÁ¿ÐèÒªDECLARE£¬ÆäËû±äÁ¿²»ÐèÒª)£»´æ´¢¹ý³Ì½áÊøÊ


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

Oracle Êý¾Ý¿âµÄ°ó¶¨±äÁ¿ÌØÐÔ¼°Ó¦ÓÃ

¹Ø¼ü´Ê:
°ó¶¨±äÁ¿(binding variable),¹²Ïí³Ø(shared buffer pool), SGA(system global area);
ÔÚ¿ª·¢Ò»¸öÊý¾Ý¿âϵͳǰ,ÓÐË­¶ÔOracle ϵͳÁ˽âºÜ¶à,ÓÈÆäÊÇËüµÄÌØÐÔ,ºÃÏóºÜÉÙ°É;¶Ô³õѧÕßÀ´½²,Õâ¸üÊDz»¿ÉÄܵÄÊÂÇé;½ö½ö¼òµ¥ÕÆÎÕÁËSQLµÄд·¨,¾Í¿ªÊ¼ÁËÊý¾Ý¿âµÄ¿ª·¢,Æä½á¹ûÖ»ÄÜÊÇ¿ª·¢Ò»¸öûÓÐЧÂÊ,ҲûÓпÉÀ©Õ¹µÄϵͳ;
Òò´Ë,ÎÒ ......

¡¶Í¿Ä¨Oracle£­Èý˼±Ê¼ÇÖ®Ò»²½Ò»²½Ñ§Oracle¡·³ö¯ÊÖ¼Ç

¡öÀÖÖª
  “Ë­ÊÇË­µÄË­”£¬ÕâÊÇΨÃÀÖÐ͸×ÅÓÄÔ¹µÄÒ»Ê׸裬µ«È´»áĪÃûµØµçµ½ÐÄÖеÄÀÛ¡£Ñ§Ï°Ì«ÀÛ£¬¹¤×÷Ì«ÀÛ£¬Éú»îÌ«ÀÛ£¬Á¬¸èÃûÌý×Ŷ¼ÄÇôÀÛ¡£
²ß»®µÄµÚÒ»±¾Êé¡¶´óÏó——Thinking in UML¡·£¬´ÓÔË×÷£¬µ½ÉÏÊУ¬µ½³©Ïú£¬µ½¾­µä£¬µ½¹úÄÚUMLµÚÒ»Ê飬һÄêÖ®ÄÚʵÏÖÁËÒ»¸ö¸öûÓÐÃιýµÄÃÎÏë¡£ÕýÈçÕâÊ׸èÖеÄÒ ......

ORACLE ÐÐתÁÐ ²âÊÔͨ¹ý£¨9i£©

--ORACLE ÐÐתÁР ²âÊÔͨ¹ý£¨9i£©
/***************************************************************************************************
ÒÔѧÉú³É¼¨ÎªÀý×Ó£¬±È½ÏÐÎÏóÒ×¶®
***********************************************************************************************************/
--1¡¢ÐÐתÁÐ
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ