ÓÃpl/sqlÍùoracleÖвåÈësqlÊý¾ÝÔõôֹͣÁËÄÇ
½ñÌìÎÒÓÃpl/sqlÍùoracleÖвåÈëÊý¾ÝµÄÊÇʱºò£¬²»ÖªµÀΪʲôÊý¾Ý×ÜÊÇĪÃûµÄ»áÔÚij¸öµØ·½Í£Ö¹¡£ ÎÒµ¼ÈëµÄÊDZðÈ˵¼³öµÄsqlÓï¾ä¡£ Ëûµ¼³öµÄ¶¼ÊÇsql£¬ËùÒÔÎÒÖ±½Ó´ò¿ªµÄpl/sql£¬ÃüÁî´°¿Ú£¬Ö±½Ó°ÑËûµ¼³öµÄsqlÓï¾äÖ±½Ó¸´ÖÆÕ³Ìù¡£ ÎÒ¾õµÄÕâÖÖ·½·¨Ã»ÓÐ´í°¡£¬ÎªÊ²Ã´ÕâÑù˵ÄÇ£¬Ö÷ÒªÊÇ£¬ÉÏÖܵÄʱºòÒ²ÊÇÕâôµ¼ÈëµÄ¾ÍûÓÐÊÂÇé¡£ ÏÖÔÚµÄÊý¾Ý¿â±íºÍÔÀ´µÄÇø±ð¾ÍÔÚÓÚ£¬±í¾Í±äÁËÒ»¸ö×ֶΣ¬½É¿îÈÕÆÚ¸ÄΪÈÕÆÚÐ͵ÄÁË¡£ÆäËûµÄ¶¼Ã»Óб䣬¡£ ÓÉÓÚÊý¾ÝÁ¿ºÜ´ó¡£ÎÒ½ñÌì²åÈëÁË3±é¡£ÕâÊǵÚ3±é£¬»¹ÊÇ»áĪÃûÆäÃîµÄÔÚij¸öµØ·½¿¨Ö÷¡£ ¿¨×¡ºó£¬ÔÙÇûسµ¾ÍûÓз´Ó¦ÁË¡£ ÕâÊÇÔõô»ØÊÂÄÇ£¬ PS: ÔÚ²åÈë֮ǰ£¬ÎÒÒѾ°ÑÔÀ´µÄÊý¾ÝºÍ±í¿Õ¼ä»¹ÓÐÓû§¶¼É¾³ýÁË¡£²»´æÔÚÖØ¸´ÎÊÌâ¡£ ´óÏÀÇó¾È£¬ÕâÊÇΪʲô°¡£¬ÎÒÔÚÏߵȡ£
Êý¾ÝÁ¿Ì«´óÁË°É Òª·ÖÅú²åÈë Ö´ÐÐcommit ÔÙ×öÏ´βÙ×÷ ¸ø³öÏêϸµÄÇé¿ö¡£±ÈÈçSQL½Å±¾¼°Êý¾ÝÁ¿¡£ PL/SQLÀïSQL´°Ö´ÐÐʱ£¬Ã»·¨Çûسµ¡£ Èç¹ûÊÇÃüÁî´°£¬ÃèÊöÏêϸ֢״¡£ ·ÖÅú´ÎÖ´ÐвåÈ룬ÿÅúÖ´ÐÐÍê±ÏÖ±½Ócommit£¬Ã¿Åú½¨ÒéÊý¾ÝÌõÊý²»³¬¹ý100Ìõ¡£Óöµ½ÈÕÆÚµÄÒªÓÃto_dateת»»³ÉÈÕÆÚÐÍ ½É¿îÈÕÆÚ¸ÄΪÈÕÆÚÐ굀 ÊÇ·ñ²åÈëµÄÀàÐÍûÓÐ×ö±ä»»£¿»òÕ߱任µÄÀàÐͲ»Ò»Ö£¬Óï¾äºÍÊý¾Ý£¬±í½á¹¹ÒýÓà ½ñÌìÎÒÓÃpl/sqlÍùoracleÖвåÈëÊý¾ÝµÄÊÇʱºò£¬²»ÖªµÀΪʲôÊý¾Ý×ÜÊÇĪÃûµÄ»áÔÚij¸öµØ·½Í£Ö¹¡£ ÎÒµ¼ÈëµÄÊDZðÈ˵¼³öµÄsqlÓï¾ä¡£ Ëûµ¼³öµÄ¶¼ÊÇsql£¬ËùÒÔÎÒÖ±½Ó´ò¿ªµÄpl/sql£¬ÃüÁî´°¿Ú£¬Ö±½Ó°ÑËûµ¼³öµÄsqlÓï¾äÖ±½Ó¸´ÖÆÕ³Ìù¡£ ÎÒ¾õµÄÕâÖÖ·½·¨Ã»ÓÐ´í°¡£¬ÎªÊ²Ã´ÕâÑù˵ÄÇ£¬Ö÷ÒªÊÇ£¬ÉÏÖܵÄʱºòÒ²ÊÇÕâôµ¼ÈëµÄ¾ÍûÓÐÊÂÇé¡£ ÏÖÔÚµÄÊý¾Ý¿â±
Ïà¹ØÎÊ´ð£º
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡ oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË ÒýÓà oracle ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle) ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......