²é¿´oracleÈÕÖ¾
¸÷λ£º
ÎÒ¿ÉÒÔÓÃtoad¹¤¾ßÔÚÊý¾Ý¿â´ò¿ªµÄÇé¿öÏ¿´µ½ÈÕÖ¾µÄÄÚÈÝ£¬µ«ÊÇÎÒÏÖÔÚµÄÊý¾Ý¿âÒòΪijÖÖÔÒò²»ÄÜ´ò¿ªÁË£¬ÎÒÒª½øÐÐÊý¾Ý¿â»ùÓÚʱ¼äµÄ²»ÍêÈ«»Ö¸´£¬Õâ¸öʱºòÎÒÏë¿´¿´ÈÕÖ¾¼Ç¼µÄÿ¸ö¶¯×÷µÄʱ¼ä£¬Ò²¾ÍÊÇÈÕÖ¾µÄÄÚÈÝ£¬ÓÉÓÚtoadÒ²ÊÇͨ¹ýÊÓͼ¿´ÈÕÖ¾µÄ£¬ËùÒÔÊý¾Ý¿âûÓдò¿ª¾Í¿´²»µ½ÈκÎÊý¾Ý£¬ÓÐûÓÐÄǸö¹¤¾ß¿ÉÒÔÔÚÊý¾Ý¿â¹Ø±ÕµÄÇé¿öÏ¿´µ½ÈÕÖ¾µÄÊý¾ÝÄÚÈÝÄØ£¿
ллÀ²£¡
ÏÈ¿´¿´alert.log£¬ÕâÀïÃæÓ¦¸ÃÓв»ÄÜopenµÄÔÒò
{{
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
лл
ÎÒÒ²ÊÇÏëÖªµÀ
me too
ÎÒ Ò² Ïë Öª µÀ Æä Ëû µÄ£¬ÎÒ ÏÖ ÔÚ ¾Í ÔÚ Ñ§ orcale Êý ¾Ý ¿â£¬ÎÒ
Óà µÄ ÊÇ ÕÔ Ôª ½Ü ±à µÄ.......
¸öÈ˾õµÃÔÀíÐԵĶ«Î÷¿´Ò»Ð©¹Ù·½Îĵµ¿ÉÄÜ»áºÃһЩ Èç¹ûûÓÐÀÏʦ½Ì ......
ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É
SQL> select name from v$database;
NAME
---------
ORCL
......
´ó¼ÒºÃ£¬ÎÒ×î½üά»¤Ò»¸öÏîÄ¿£¬100¶à¸ö±í
Ö»ÄÜÓÃjdbcÖ±Á¬
Óöµ½Á˶à¸ö±í ¹ØÁª ²éѯµÄÇé¿ö Çë´ó¼ÒÖ¸½Ì
±ÈÈç
student(studentid,classid)
class(classid,classname)
class_teacher(classid,teacherid)Õâ¸öÊÇÖмä±í ......