Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

server 2000Êý¾Ý×ªÒÆµ½oracle - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔ­À´oracleÀïµÄÔ­ÓеÄÊý¾Ý¿â,Ö»ÄÜн¨

ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......

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

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......

oracle °²×° 01092 ´íÎó - Oracle / »ù´¡ºÍ¹ÜÀí

oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log 
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......

oracleµÄ°²×°ºÍʹÓúÃÄѰ¡ - Java / Java EE

oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿Ô­À´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ