а²×°oracle£¬Ã»ÓмàÌý·þÎñ
¸Õ°²×°Á˸öoracle9£¬xpÏµģ¬µ«ÊÇÔÚ´´½¨×ÊÁϵµ°¸¿âµÄʱºòÌáʾûÓмàÌýÆ÷£¬Ê¹ÓÃsqlplusµÄʱºòÒ²ÊÇ£¬ÉÏÍø²éÁËÏÂ×ÊÁÏ£¬¶¼ËµÊǼàÌý·þÎñûÓпªÆô£¬µ«ÎÒÕÒÁËÏÂÎҵķþÎñÀïÃæ¾ÍûÓмàÌý·þÎñ°¡£¬ÊÇÎҵݲװÎļþÓÐÎÊÌâô£¿»¹ÊÇÔõô»ØÊÂÄØ£¿
Ó¦¸ÃÊÇûÓа²×°ÍêÈ«¡£ÔÚ½¨¿âÍêÒԺ󣬾ͻáÌáʾÄã°²×°¼àÌýÆ÷µÄ¡£
OEM¿ØÖÆÌ¨·ÖÁ½ÖÖ·½Ê½Æô¶¯£¬µÚÒ»ÖÖ¶ÀÁ¢Æô¶¯£¬ÕâÖÖ·½Ê½ÊÇÖ±½ÓµÇ¼µ½Ä³¸öÊý¾Ý¿âµÄ
¶øÁí´¦Ò»ÖÖ·½Ê½ÊǵǼµ½¹ÜÀí·þÎñÆ÷ÉÏ£¬¶øµÇ¼µ½¹ÜÀí·þÎñÆ÷¾ÍÒªÓõ½×ÊÁϵµ°¸¿â¡£ÎªÊ²Ã´ÒªÓÃ×ÊÁϵµ°¸¿â
ÒòΪµÇ¼µ½OMSÉϵÄOEM¿ØÖÆÊÇ¿ÉÒÔͬʱ¹ÜÀí¶à¸öÊý¾Ý¿âµÄ£¬¶ø¶ÀÁ¢Æô¶¯ÊÇÖ»ÄܹÜÀíÒ»¸öµÄ£¬Õâ¸ö×ÊÁϵµ°¸¿â¾Í
ÊÇÓÃÀ´´æ·ÅÓйز»Í¬Êý¾Ý¿âµÄ¹ÜÀíÐÅÏ¢µÄ¡£
µ«ÊÇÔÚÁíһ̨»ú×ÓÉÏÒ²ÊÇÒ»ÑùµÄ°²×°£¬¾ÍÓмàÌý·þÎñÄØ
»¹ÓÐÇëÎÊϵǽ¿ØÖÆÌ¨µÄʱºòÄǸömanagement serverÊÇ»úÆ÷Ãûô£¿Ã»Óùýoracle¸Õ¿ªÊ¼Ñ§»¹Çë´ó¼Ò¶àÖ¸µã
ÓÃdbca´´½¨ÊµÀý
net manager ÖØÐÂÅäÖÃÒ»¸ö
ÖØÐÂÅäÖÃһϼàÌý£º
Oracle Êý¾Ý¿â¼àÌýÅäÖÃ
http://blog.csdn.net/tianlesoftware/archive/2009/11/24/4861572.aspx
ǰ¼¸ÌìҲ¼ÁËÒ»¸öOracle ¼àÌýÅäÖõÄÊÓÆµ£¬¸ÐÐËȤ£¬¿ÉÒÔ¿´¿´¡£
------------------------------------------------------------------------------
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
ÔÚÃüÁîÐÐÊäÈ룺
c:\>netca
È»ºóÓнçÃæ³öÀ´£¬ÅäÖÃÒ»Ï
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......
±¾ÈËÏÖÔÚѧoracle ËãÊǸոÕÈëÒ»°ëÃÅ ÒÔºó»¹ÒªÑ§java ¸÷λ´óÏÀoracleºÃÈëÊÖ»¹ÊÇjavaºÃÈëÊÖ°¡ ÒÔºóÄǸö·½Ãæ·¢Õ¹»áºÃЩ
£¬ÎÒÔÝʱÓиöÏë·¨ÏëºÃºÃѧϰһÏÂÊý¾Ý¿âÒÔºóÍùÕâ·½±ã·¢Õ¹£¬±Ï¾¹Êý¾Ý¿â¸úл»´úûÓÐjavaÄÇô¿ì£¬²» ......