oracleµ¼Èëµ¼³ö¹¤¾ß
Çë½ÌÏ´óÏÀ£¬ÔÚ²»Ê¹ÓÃÃüÁîµÄÇé¿öÏ£¬oracleÊý¾Ý¿âÓÃÄÄÖÖ¹¤¾ß±È½ÏºÃÓã¬ÒòΪÓÃÃüÁîÔ¶³Ì¿ØÖƲÙ×÷ϵͳ²»Ò»Ñù£¬»á³ö´í£¬²»ÄÜÓÃÃüÁîÖ±½ÓÕýÈ·µÄµ¼È룬Çë´ó¼Ò½éÉÜÏÂoracleµÄ×îºÃÓù¤×÷£¬¿ÉÒÔÖ±½Óµ¼Èëµ¼³ö£¬¶øÇÒÒ»²½µ½Î»²»»áÓÐÎÊÌ⣬»¹ÓÐÏ£Íû¿ÉÒÔÊÊÓ¦¶àÖÖ²Ù×÷ϵͳ¡£Navicat¹¤¾ßºÍPL/SQL¾õµÃ²»ÊǺܺÃÓã¬ÈÝÒ׳ö´í£¬¿´¿´ÓÐûÓÐÆäËûµÄ£¬Ð»Ð»ÁË
ÓÃsqlServerµÄÄǸö¹¤¾ß°É..¸Ð¾õÂúºÃµÄ..¾Í²»ÏþµÃÄã×°ÁËsqlserverûÓÐ.. ͵ÀÁ¾ÍÓÃÄǸö toadÈçºÎ£¿ Ä¥µ¶²»Îó¿³²ñ¹¦£¬»¨µãʱ¼äÊìϤһÏÂexp,imp°É ²Î¿¼£º http://blueicer.blog.51cto.com/395686/101600 лл»Ø´ð£¬sqlServerûÓÐÓùý£¬¸Õ×°ÁËsqldeveloper£¬¿´¿´Õâ¸öÔõÑù toadÕâ¸öÓÐ×°ÁË£¬µ«ÊÇûȥÊìϤºÃÏñ²»ÔõôºÃÓã¬ÃüÁî²»ÈÃʹÓã¬ÈÝÒ׳ö´í£¬µ½ÁËÓ¢ÎĵIJÙ×÷ϵͳÎļþ¾Í±»Ëð»µÁË PL/SQL ºÜºÃÓð¡ Èç¹ûÊý¾ÝÁ¿ÉÙ£¬¿ÉÒÔºÍExcelÖ±½Ó¸´ÖÆÕ³ÌùÊý¾Ý£¬×î·½±ã plsql devloperÎı¾Êý¾Ýµ¼Èëµ¼³öºÜºÃÓà Èç¹ûµ¼Èëµ¼³öexcel »¹ÊÇʹÓÃtoad°É sqldeveloper±È½ÏÒ²ºÃÓ㬱¾µØ²»Óð²×°OracleÒ²¿ÉÒÔʹÓøù¤¾ßÁ¬½ÓÔ¶³ÌOracleÒýÓà Çë½ÌÏ´óÏÀ£¬ÔÚ²»Ê¹ÓÃÃüÁîµÄÇé¿öÏ£¬oracleÊý¾Ý¿âÓÃÄÄÖÖ¹¤¾ß±È½ÏºÃÓã¬ÒòΪÓÃÃüÁîÔ¶³Ì¿ØÖƲÙ×÷ϵͳ²»Ò»Ñù£¬»á³ö´í£¬²»ÄÜÓÃÃüÁîÖ±½ÓÕýÈ·µÄµ¼È룬Çë´ó¼Ò½éÉÜÏÂoracleµÄ×îºÃÓù¤×÷£¬¿ÉÒÔÖ±½Óµ¼Èëµ¼³ö£¬¶øÇÒÒ»²½µ½Î»²»»áÓÐÎÊÌ⣬»¹ÓÐÏ£Íû¿ÉÒÔÊÊÓ¦¶àÖÖ²Ù×÷ϵͳ¡£Navicat¹¤¾ßºÍPL/SQL¾õµÃ²»ÊǺܺÃÓã¬ÈÝÒ׳ö´í£¬¿´¿´ÓÐûÓÐÆäËûµÄ£¬Ð»Ð»ÁË Ò»°ãplsql×ãÒ࣡ÒýÓà Çë½ÌÏ´óÏÀ£¬ÔÚ²»Ê¹ÓÃÃüÁîµÄÇé¿öÏ£¬oracleÊý¾Ý¿âÓÃÄÄÖÖ¹¤¾ß±È½ÏºÃÓã¬ÒòΪÓÃÃüÁîÔ¶³Ì¿ØÖƲÙ×÷ϵ
Ïà¹ØÎÊ´ð£º
Á½¸öÎļþ1.PC£¬1.inc 1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡ oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË ÒýÓà oracle ......
eclipse 3.3Æô¶¯web¹¤³Ì£¬ÒªÁ¬½Óoracle9iÊý¾Ý¿â±¨ ÑÏÖØ: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error: ORA-12518, TNS:listener could not hand off cli ......
²é¿´ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁ MySQLʹÓõÄÊÇselect @@tx_isolation; ÔÚOracleÖв鿴ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁîÊÇÄĸö£¿ SQL code: SELECT /*+ rule */ s.username,decode(l.type,'TM','TABLE LOCK','TX','ROW LOCK', ......