OracleµÄDBConsoleÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí
СµÜÎÒÕâѧÆÚÔÚѧOracle¡£°²×°ÁËOracle 10.2.0°æ±¾¡£µ«³öÏÖÁËÈçÏÂÎÊÌâ¡£ ORACLEÊý¾Ý¿âµÄORCLÊý¾Ý¿âÄÜͨ¹ýemÀ´¹ÜÀí£¬ÓÐoracleDBConsoleorcl·þÎñ¡£ È»ºóÎÒ×Ô¼ºÐ½¨ÁËÒ»¸öÊý¾Ý¿â¡£·¢ÏÖ·þÎñÀïʲô·þÎñ¶¼ÓУ¬¾ÍÊÇûÓÐoracleDBConsoleorcl·þÎñ¡£ ÓôÃÆËÀÁË¡£ »á²»»áÊǰ汾µÄÎÊÌâѽ¡£ÄѵÀÒªÖØ×°£¿ÅµÈÏÂ֨װ»á¸ü³öÎÊÌ⣬ʲô²ÐÓà×¢²á±íµÈµÄÌØÂé·³¡£ »¹Íû¸ßÊÖÃÇÖ¸µãÖ¸µã¡£
ÒýÓà СµÜÎÒÕâѧÆÚÔÚѧOracle¡£°²×°ÁËOracle 10.2.0°æ±¾¡£µ«³öÏÖÁËÈçÏÂÎÊÌâ¡£ ORACLEÊý¾Ý¿âµÄORCLÊý¾Ý¿âÄÜͨ¹ýemÀ´¹ÜÀí£¬ÓÐoracleDBConsoleorcl·þÎñ¡£ È»ºóÎÒ×Ô¼ºÐ½¨ÁËÒ»¸öÊý¾Ý¿â¡£·¢ÏÖ·þÎñÀïʲô·þÎñ¶¼ÓУ¬¾ÍÊÇûÓÐoracleDBConsoleorcl·þÎñ¡£ ÓôÃÆËÀÁË¡£ »á²»»áÊǰ汾µÄÎÊÌâѽ¡£ÄѵÀÒªÖØ×°£¿ÅµÈÏÂ֨װ»á¸ü³öÎÊÌ⣬ʲô²ÐÓà×¢²á±íµÈµÄÌØÂé·³¡£ ¡¡ Ī·Ç°²×°Êǿͻ§¶Ë£¿ Oracle ÏÂÔØµØÖ· http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------------------------------------------ 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 ºÇºÇ¡£ËµµÃÓÐÀí¡£Ð¡µÜÔÚ´Ëл¹ý¡£ÒýÓà СµÜÎÒÕâѧÆÚÔÚѧOracle¡£°²×°ÁËOracle 10.2.0°æ±¾¡£µ«³öÏÖÁËÈçÏÂÎÊÌâ¡£ ORACLEÊý¾Ý¿âµÄORCLÊý¾Ý¿âÄÜͨ¹ýemÀ´¹ÜÀí£¬ÓÐoracleDBConsoleorcl·þÎñ¡£ È»ºóÎÒ×Ô¼ºÐ½¨ÁËÒ
Ïà¹ØÎÊ´ð£º
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl"; private static final String USERNAME = "sys"; private static final String PASSWORD = "s ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó #topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬ Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04 #lslv -l lv04
......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£ ¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£ ¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿ ......
SELECT * from (SELECT A.*, ROWNUM RN from (SELECT * from t_out_logon) A WHERE ROWNUM <= 30)WHERE RN >= 21 SELECT A.* from (SELECT t.*,rownum rn from t_out_logon t WHERE ROWNUM <= 30) A WHERE ......