Çë½Ì ѧϰORACLEÊé¼®
ÓÐÄÄЩÊé¼®ÊÇѧϰoracle¿ª·¢±È½ÏºÃµÄÊé¼®£¿
Oracle9iHelp Oracle10gSQLRef Oracleר¼Ò¸ß¼¶±à³Ì ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ£¨µÚËİ棩¡· Íõɺ ÈøÊ¦ìÓ ¸ßµÈ½ÌÓý³ö°æÉç (ÕÆÎÕ»ù´¡ÖªÊ¶ºÍ¸ÅÄî) È»ºóÔÙ´ÖÂÔä¯ÀÀÒ»±éOracleµÄ¹Ù·½Êֲᡣ£¨·½±ãÒÔºó²éÕÒ£¬±ÜÃâÀàËÆÓÚ¿¼ÊÔµÄʱºò£¬¸øÄã±¾ÕþÖÎÊéÒ²²»ÖªµÀ´ð°¸ÔÚµÚ¼¸Õ£¬µÚ¼¸Ò³£© »ù´¡µÄ£º Oracle 10g ÈëÃÅÓëÌá¸ß ¾«Í¨Oracle 10g PL/SQL±à³Ì£¨ÍøÉÏÓеç×ÓÊ飩 OCPÈÏÖ¤¿¼ÊÔÖ¸ÄÏÈ«²áOracle Database 10g ½ø½×·½ÃæµÄ£º oracleʵÓü¼ÊõÏê½â Oracle 9i/10g±à³ÌÒÕÊõ Oracle database 10g ÐÔÄܵ÷ÕûÓëÓÅ»¯ ×îÈ«ºÍ×îȨÍþµÄ£º oracle×Ô´øÎĵµÒýÓà »ù´¡µÄ£º Oracle 10g ÈëÃÅÓëÌá¸ß ¾«Í¨Oracle 10g PL/SQL±à³Ì£¨ÍøÉÏÓеç×ÓÊ飩 OCPÈÏÖ¤¿¼ÊÔÖ¸ÄÏÈ«²áOracle Database 10g ½ø½×·½ÃæµÄ£º oracleʵÓü¼ÊõÏê½â Oracle 9i/10g±à³ÌÒÕÊõ Oracle database 10g ÐÔÄܵ÷ÕûÓëÓÅ»¯ ×îÈ«ºÍ×îȨÍþµÄ£º oracle×Ô´øÎĵµ up... ------------------------------------------------------------------------------ Blog£º http://blog.csdn.net/tianlesoftware ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx DBA1 Ⱥ£º62697716(Âú); DBA2 Ⱥ£º62697977 ¡¶Oracle DBA Åàѵ½Ì³Ì¡· ¡¶Oracle Database 10g SQL¿ª·¢Ö¸ÄÏ¡· ¡¶ÉîÈë½âÎöOracle——DBAÈëÃÅ¡¢½ø½×ÓëÕï¶Ï°¸À
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿ 1 ¿ÉÒÔɾ³ý 2 ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿ Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£ ²»ÄÜÖ±½ÓÁ¬½ÓÂ𣿠ÒýÓà ²»ÄÜÖ±½ÓÁ¬½ÓÂ𣿠²»ÄÜ ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿ µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿ 3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......