server 2000Êý¾Ý×ªÒÆµ½oracle - Oracle / »ù´¡ºÍ¹ÜÀí
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓà °²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ÒµÄ£Ä£Ô£Áµ¹Êý¾Ý¡£ ͬÒâ¡£ ÓÃһЩdtsµÄ¹¤¾ß£¬Oralce×Ô¼ºµÄOracle sql developerÒ²¿ÉÒÔ Ïȷŵ½EXCEL ÖÐ,ÔÙµ¼µ½ORACLE ÓÃmssqlµÄdtsµ¼£¬µ«ÊÇÁ½ÖÖÇé¿öÒªÌØÊâ´¦Àí£¬¿ÉÒÔÓóÌÐò´¦Àí£º 1¡¢·Ç¿Õ×ֶΣ¬oracleµÄ''ÈÏΪÊÇnull 2¡¢text×Ö¶ÎÒýÓà °²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ÒµÄ£Ä£Ô£Áµ¹Êý¾Ý¡£ ÕâÖÖ·½·¨¿Ï¶¨¿ÉÒÔ¡£Ã»Óùý ʹÓÃoracleÊý¾Ý¿â͸Ã÷Íø¹Ø£¬½«sqlserver 2000 µÄÊý¾Ýͬ²½µ½oracleÊý¾Ý¿âÖС£ ѧϰÁË¡£ ûµ¼¹ý£¬Ñ§Ï°
Ïà¹ØÎÊ´ð£º
ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿ Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É SQL> select name from v$database; NAME --------- ORCL
......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
score±í scoreid course studentid score 1 Êýѧ 2 99 2 Êýѧ 3 60 3 Êýѧ 4 80 4 ÓïÎÄ 5 79 5 ÓïÎÄ 6 58 6 ÓïÎÄ 1 66 7 Ó¢Óï 6 76 8 Ó¢Óï 4 87 9 Ó¢Óï 3 100 10Ó¢Óï 2 69 ÔõÑùµÃµ½Ã»ÃÅ¿ÎÖзÖÊý×î¸ßµÄÄÇ ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡ oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË ÒýÓà oracle ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......