PL/SQL Á¬½ÓOracle£¬N¾ÃûÁ¬ÉÏ£¡¾È¼±
±¾ÈË×°µÄÊÇplsql7.0£¬»úÆ÷ÉÏûÓа²×°Oracle¿Í»§¶Ë£¬ÊDzÉÈ¡ÍøÉÏÄÇÖÖ¼òÒ×°²×°À´°²×°µÄ£¬ ¿ªÊ¼Ö®³õÊÇ¿ÉÒÔÁ¬ÉÏOracleÊý¾Ý¿â·þÎñÆ÷£¬¿ÉÊÇijÌìÖØÐ°²×°ÁËÒ»´ÎOracle¿Í»§¶Ë£¬ÇÒ°ÑOracle¿Í»§¶Ëɾ³ýºó£¬ ÔÙÀûÓÃÍøÉϵÄÂÌÉ«Á¬½ÓOracle·½·¨£¬¾Í²»¿ÉÐÐÁË ´óÅ£ÃÇ£¬¾È¾È¼±°¡°¡°¡°¡°¡£¡£¡
ÕÒÏÂtnsnames.oraÎļþ£¬¿´¿´Á¬½ÓÊÇ·ñÅäÖÃÕýÈ· plsqlÖÐÓиöÑ¡ÏÉèÖóÉoracleName¾Í¿ÉÒÔÁËÒýÓà ÕÒÏÂtnsnames.oraÎļþ£¬¿´¿´Á¬½ÓÊÇ·ñÅäÖÃÕýÈ· up ÓÐʲôÌáʾ£¬Ìù³öÀ´¿´Ò»Ï¡£ÒýÓà ÒýÓà 1 Â¥ csuxp2008 µÄ»Ø¸´: ÕÒÏÂtnsnames.oraÎļþ£¬¿´¿´Á¬½ÓÊÇ·ñÅäÖÃÕýÈ· up ÎÒµÄtnsnames.oraÎļþÈçÏ£º # TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora # Generated by Oracle configuration tools.(SERVER = DEDICATED) # Çë¸ù¾Ýʵ¼ÊÇé¿öÔÚ±¾ÎļþÖÐÔö¼ÓÏàÓ¦µÄÁ¬½Ó²ÎÊý DDDD_X.X.X.X = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = X.X.X.X)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = DDDD_192.168.242.26) ) ) ²é¿´²¢È·ÈÏÄãµÄʵÀýÃûÊÇ·ñÊÇDDDD_192.168.242.26 ¸öÈ˾õµÃ×îºÃ±ðÓÃ. ¼ì²éÁ¬½ÓÊÇ·ñÕýÈ· ÔÚPLSQL DeveloperÖÐÑ¡Ôñ ¹¤¾ß-Ê×Ñ¡Ïî£Á¬½Ó,ÒÔÏÂÁ½ÏîÐèÕýÈ·ÅäÖà Oracle Ö÷Ŀ¼Ãû OCI¿âÒýÓà ¼ì²éÁ¬½ÓÊÇ·ñÕýÈ· ÔÚP
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º 1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã© Ñ¡ÔñºÃÎļþºó µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏ 2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql 3 ......
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ ÒýÓà ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡ oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË ÒýÓà oracle ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......