oracle ¿ÉÊÓ»¯¿´±íÄÚÈÝ - Oracle / »ù´¡ºÍ¹ÜÀí
ÎÒ°²×°ÁËoracle 10g¾¹ýÒ»·¬Å¬Á¦Äܹ»Ë³ÀûµÄÁ¬½ÓÉÏÁË£¬ µ«ÊÇÎÒÒÔǰÓõÄÊÇsql server ËûµÄÆóÒµ¹ÜÀíÆ÷ÖÐÄÜ¶Ô±í½øÐпÉÊÓ»¯¹ÜÀí ÔÚoracleÖÐÎÒÒ²¿´µ½ÁËÓпÉÊÓ»¯µÄem µ«ÊÇÎÒ¾ÍÊÇ¿´²»µ½±íµÄÄÚÈÝÀ´ ÇëÎÊÓÐûÓдóϺÄܰï°ïæ!
µ«ÊÇÎÒ¾ÍÊÇ¿´²»µ½±íµÄÄÚÈÝÀ´ SELECT ¾Í³öÀ´ÁË£¬¡£¡£¡£¡£¡£¡£ »¹ÊǵÃÓÃsqlplusÂ𣿠³õѧÕߣ¬»¹ÊÇ×°Ò»¸öµÚÈý·½¹¤¾ß°É£¬pl/sql developer ÈÝÒ×ÉÏÊÖ£¬¸üÏósql serverµÄÆóÒµ¹ÜÀíÆ÷ pl/sql developer¸úToad£¬Á½¸ö¶¼ºÜÁ÷ÐÐ ×°¸ö11g Ò²¿ÉÒÔ, ÀïÃæÓиö sqldevelop ÄãÒª¿´±íÄÚÈÝ£¬ÈçÉÏËù˵£ºSELECTһϲ»¾Í³öÀ´ÁËô£¬ºÇºÇ£¬ÆäʵORACLE 9IÒ²ÓÐÒ»¸ö±¾µØµÄÆóÒµ¹ÜÀíÆ÷£¬ORACLE 10Gºó¾ÍÈ«ÊÇWEB°æ±¾µÄÆóÒµ¹ÜÀíÆ÷ÁË£¬²»¹ý²»ÂÛÄÇÒ»ÖÖ£¬ËûµÄ¿ÉÊÓ»¯²Ù×÷ÐÔ¶¼Ã»ÓÐ΢Èíɵ¹Ïʽ²Ù×÷ÄÇô·½±ãÁË£¬Ò»°ã±È½Ï·½±ãµÄ²Ù×÷¶¼ÊÇÓõÚÈý·½µÄPL/SQL(Ãâ·Ñ)»òÕßToad£¨ÓаæÈ¨£©¡£²»¹ýÓÉÓÚORACLE±¾ÉíÄÚ²¿¶«Î÷·Ç³£¶à£¬ËùÒÔÕâЩµÚÈý·½Ö»ÊÇÌṩÁËһЩ³£ÓõÄÅäÖÃÐÅÏ¢£¬¸ü¶à¸üÉîÈëµÄ¶«Î÷»¹ÊÇÒªÓÃORACLEÌṩµÄsqlplus»òÕßsqlplusw¹¤¾ß¡£²»¹ýÒ»°ã¶ÔÓ¦»ù±¾¿ª·¢£¬³£ÓõÄÒѾ×ã¹»ÁË£»ÌØÊâµÄÎÒ¼òµ¥¾ÙÁ½¸öÀý×Ó£ºÈç·ÖÇø±í»òÕßcacheÒÔ¼°´æ´¢Î»ÖÃÉèÖÃÐÅÏ¢£¬Ö±½ÓÓÃPL/SQL±à¼±í²é¿´Ô´ÂëÊÇ¿´²»µ½µÄ£»ÁíÍâÈçÖ´ÐÐORACLE_HOME/RDBMS/ADMIN/ ÏÂÃæµÄÀ©Õ¹°ü£¨È磺SYS.DBMS_SHARED_POOLÓÃÓÚ½«¶ÔÏóKEEPµ½¹²Ïí³ØµÄ°ü£©£¬ÕâЩ°üÓõÚÈý·½µÄ¹¤¾ßÀ´Ö´ÐÐÍùÍù²»ºÃÓã¬ÐèÒªµ½SQLPLUSÏÂÈ¥Ö´ÐвÅÄܳɹ¦¡£ÒýÓà ÄãÒª¿´±íÄÚÈÝ£¬ÈçÉÏËù˵£ºSELECTһϲ»¾Í³öÀ´ÁËô£¬ºÇºÇ£¬ÆäʵORACLE 9IÒ²ÓÐÒ»¸ö±¾µØµÄÆóÒµ¹ÜÀíÆ÷£¬ORACLE 10Gºó¾ÍÈ«ÊÇWEB°æ±¾µÄÆóÒµ¹ÜÀíÆ÷ÁË£¬²»¹ý²»ÂÛÄÇÒ»ÖÖ£¬ËûµÄ¿ÉÊÓ»¯²Ù×÷ÐÔ¶¼Ã»ÓÐ΢Èíɵ¹Ïʽ²Ù×÷ÄÇô·½±ãÁË£¬Ò»°ã±È½Ï·½±ã
Ïà¹ØÎÊ´ð£º
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Ä ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql declare TYPE test_rec IS record( code varchar(10), name varchar(30) ); v_book test_rec; ......
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ÔÚ XP ÐüÉÍ·Ö£º105 - ½â¾öʱ¼ä£º2008-9-23 23:39 ÎÒÖ»°Ñoracle×°ÔÚÁËE:\oracleÖÐ »·¾³±äÁ¿²»ÖªµÀÈçºÎÅäÖÃ. XPϰ²×°ORACLE ûÓÐÐèÒªÅäÖõĻ·¾³±äÁ¿ ¿ÉÒÔͨ¹ýEMÅäÖÃÏ·þÎñÃûº ......