Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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»¹ÊÇ×Ô¼º¿´×ÊÁÏ×Ô¼ºÃþË÷±È½ÏºÃ£¬±ðÈ˸æËßÄãµÄÓÀÔ¶ÊÇÒ»Ð©Æ¬ÃæµÄ¶«Î÷¡£

°¥¡­¡­ ¹Ø¼üÎÒÊÇ¿´²»¶®°¡£¬ÕâºÜÈÃÎÒÓôÃÆ¡£ÎÒѧµÄ¶«Î÷¶¼ÊÇ´Óʵ¼ù¹ýÀ´µÄ£¬Ö®ºó²Åż¶û¿´¿´ÊéѧϰһЩµ×²ãµÄ¶«Î÷¡£¹Ø¼ü¸Õ¿ªÊ¼Ì«·Ñʱ¼äÁË£¬¹¤×÷Ò


Ïà¹ØÎÊ´ð£º

Oracle Êý¾Ýµ¼³öÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......

oracle 10g°²×°µ½85%ʱ±¨´í

¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿

ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..

ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ