oracleÊý¾Ý¿â¡¢±í¿Õ¼ä
ÎÒÊǸöoracleµÄ³õѧÕß¡£ÒòΪÒÔǰÓõÄÊÇMySQLºÍmssql£¬ËùÒÔÔÚѧoracleµÄʱºòÓеãÎóÇø¡£Ï£Íû¸ßÊÖÃǶà°ï°ïæ¡£ 1.ÎÒǰ¼¸ÌìÔÚÕâÀïÌá¹ýÎÊÌ⣬¾ÍÊÇoracleµÄÓû§ÊDz»ÊÇÏ൱ÓÚsqlµÄÒ»¸öÊý¾Ý¿â£¬»Ø´ðÊǿ϶¨µÄ£¬µ«ÊÇÎÒÔÚÍøÉϲ鵽µÄ½á¹ûȴ˵oracleµÄ±í¿Õ¼äÏ൱ÓÚsqlµÄÒ»¸öÊý¾Ý¿â£¬Õâµ½µ×ʲôÊÇÕýÈ·µÄ°¡£¿ 2.ÎÒ¸Õµ½ÏÖÔڵĹ«Ë¾²»³¤Ê±¼ä£¬ÒòΪ¸Õ¸Õ½Ó´¥Oracle£¬ËùÒÔÏë×Ô¼ºÑо¿Ò»Ï£¬ÎÒÃǵÄOracleÔÚaixµÄϵͳÏ£¬oracleÀïÃæ»¹ÓÐÎÒÃÇÓõIJâÊԵĶ«Î÷£¬ÎÒÓÃselect name from v$database;ÏÔʾxyzsµÄÒ»¸öÊý¾Ý¿â¡£ÄÇôÕâ¸öÊý¾Ý¿âÊÇʲôÒâ˼£¿µÇ½Óû§µÄÓµÓдËÊý¾Ý¿âô£¿»¹ÊÇÕû¸öoracle¾ÍÕâÒ»¸ö¿â£¿ 3.ÎÒÏëÒª×Ô¼ºÑо¿Ò»ÏÂoracle£¬ÓõľÍÊÇÎÒÃǹ«Ë¾µÄ»·¾³¡£ÎÒдÁËÒ»¶Î´úÂ룬ÏÖÔÚÐèÒª½¨Ò»¸öÊý¾Ý¿â£¨¾ÍÏñmssql£©µÄÄÇÑùµÄ¿â£¬ÍøÉÏÓÐÈ˸æËßÎÒ½¨Ò»¸öÓû§ÔÙ½¨Ò»¸ö±í¿Õ¼ä¾Í¿ÉÒÔÁË£¬µ«Èç¹ûÎÒ½¨ÁËÒÔºó»á²»»áÔÚxyzsÏÂÃæÄØ£¬¶ÔÎÒÃDzâÊÔµÄÊý¾Ý¿âÓÐûÓÐÓ°ÏìÄØ£¿±ðÈ˻ῴµ½Ã´£¿ÎÒ×Ô¼ºÒª×ö¸ötest¿âÁ¬½Ó×Ô¼ºµÄ³ÌÐòÓ¦¸ÃÔõô×öÄØ£¿ÖØÐ½¨¸ö¿â»¹Êǽ¨¸öÓû§ºÍ±í¿Õ¼ä¾Í¿ÉÒÔÁËÄØ£¿ Çëǰ±²ÃÇÖ¸µãһϡ£Ð»Ð»£¡
ºÃÏñÉÏ´ÎÓÐÈËÎʹýÁËÀàËÆµÄÎÊÌâ¡£ÏÂÃæÊÇÌû×ÓµÄÁ´½Ó£º http://topic.csdn.net/u/20100329/11/ed383ba0-7ca3-4fd5-8b49-46150667b927.html ÕâЩ¶¼ÊÇORACLEµÄ»ù±¾µÄ¶«Î÷£¬½¨ÒéÂ¥Ö÷ÏÈ¿´Ò»Ð©ORACLE»ù´¡·½ÃæµÄ×ÊÁÏ£¬Èç¹Ù·½Îĵµ¡£ ÕâЩ»ù´¡ÖªÊ¶lZ»¹ÊÇ×Ô¼º¿´×ÊÁÏ×Ô¼ºÃþË÷±È½ÏºÃ£¬±ðÈ˸æËßÄãµÄÓÀÔ¶ÊÇÒ»Ð©Æ¬ÃæµÄ¶«Î÷¡£ÒýÓà ÕâЩ»ù´¡ÖªÊ¶lZ»¹ÊÇ×Ô¼º¿´×ÊÁÏ×Ô¼ºÃþË÷±È½ÏºÃ£¬±ðÈ˸æËßÄãµÄÓÀÔ¶ÊÇÒ»Ð©Æ¬ÃæµÄ¶«Î÷¡£ °¥¡¡ ¹Ø¼üÎÒÊÇ¿´²»¶®°¡£¬ÕâºÜÈÃÎÒÓôÃÆ¡£ÎÒѧµÄ¶«Î÷¶¼ÊÇ´Óʵ¼ù¹ýÀ´µÄ£¬Ö®ºó²Åż¶û¿´¿´ÊéѧϰһЩµ×²ãµÄ¶«Î÷¡£¹Ø¼ü¸Õ¿ªÊ¼Ì«·Ñʱ¼äÁË£¬¹¤×÷Ò
Ïà¹ØÎÊ´ð£º
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿ ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ.. ÒýÓà ¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ emp_no emp_name ------- ------------ 0001 TOM 0002 JOHN 0003 MARY ³£Óõ绰 ¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput) 0001,TOM 0002,JOHN
......