Çë½Ì ѧϰ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·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ ÒýÓà ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡ oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË ÒýÓà oracle ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql declare TYPE test_rec IS record( code varchar(10), name varchar(30) ); v_book test_rec; ......
Õâ¸öSQLÓï¾äÔõôд? ÏÖÔÚÓÐÒ»¸ö±íT,ÀïÃæ¾Í3¸ö×ֶΠѧÉúID(sid)¿Î³Ì(cName)³É¼¨(score) 1 1 75 2 2 90 3 2 60 4 3 89 5 3 80 6 3 70 ÎÒÏÖÔÚÏëÖªµÀµÃµ½µÄ½á¹ûÊÇ:ÿÃſγÌÅÅÔÚǰÁ½ÃûµÄѧÉúµÄID,Ó¦¸ÃÔõÃ´Ð´ÄØ?
......