΢Èí£º×ö×Ô¼ºµÄÇ¨ÒÆ¹¤¾ß£¬ÈÃOracleÈ¥×ż±°É£¡
¿ªÔ´¿çƽ̨±à³ÌÓïÑÔJava¼ÓÉÏ¿ªÔ´Êý¾Ý¿âMySQL£¡×ÔSunÊÕ¹ºMySQL¿ªÊ¼£¬±¾ÒÔΪSun½«´óÕ¹ºêͼ¡£È»SunȴûÓаÑÎÕ»ú»á£¬·´¶øÃ»ÓнûµÃס½ðÈÚΣ»úµÄ³å»÷¡£ÂäµÃ¸öÃæÁÙÊÕ¹ºµÄ¾ÖÃæ¡£»òÐíMySQLÖ®¸¸Richard StallmanÒ²¾ø¶ÔûÓÐÏëµ½£¬ÈÃSunÊÕ¹ºMySQL£¬È´ÊǰÑMySQLÍÆÏòÁËÉîÔ¨¡£MySQLµÄºÎÈ¥ºÎ´Ó£¡
Ãæ¶ÔÕâ¸öÎÊÌ⣬MySQLÖ®¸¸Richard StallmanºÍÓû§½Ï¶àµÄÅ·ÃË×ø²»×¡ÁË¡£Richard Stallman·¢±íÉùÃ÷£ºMySQL±»²¢¹º ¿ªÔ´Êý¾Ý¿â½«µ¹ÍËÊ®Ä꣬²¢ÏòÅ·ÖÞίԱ»áµÄίԱNeelie Kroes£¬ÇëÇó²»ÒªÈÃOracleºÏ²¢MySQL¡£Å·ÃËÔòÒ»Ö±ÍÆ³ÙÉóÅú¡£
Õⳡ·×Õù»ñÀûÊÇË£¿
Ê×ÏÈ£¬¿´×î½üµÄ±¨µÀ£ºÎ¢Èí·¢²¼MySQL to SQL ServerÇ¨ÒÆ¹¤¾ß CTP1.0 ¡£
΢ÈíЦÁË£¬ÕýËùν£¬Ö»Òª³úÍ·ÎèµÃºÃ£¬Ã»ÓÐǽ½ÇÍÚ²»µ¹£¨ÓÉÓÚûÓÐʹÓùýCTP1.0£¬Ôݲ»¶Ô΢ÈíµÄÕâ°Ñ³úÍ·½øÐÐÆÀ¼Û£©¡£¸üºÎ¿öÏÖÔÚMySQLµÄ´¦¾³ÓÖÊÇÈç´ËµÄÈÃÈ˵£ÓÇ£¬Óû§Á÷ʧÊDZØÈ»µÄ¡£Î¢Èí¿ªÊ³MySQLµÄÊг¡·Ý¶îµÄÕâÖÖ×ö·¨£¬ÕâÎÞÒÉÊǸøMySQLµÄµ±Í·Ò»°ô¡£OracleÄØ£¿ÎÒÏëËüÒ²Ïë·¢²¼Ò»¸öÇ¨ÒÆ¹¤¾ß°É¡£²»¹ýÏÔÈ»£¬OracleÖ»ÄÜ¿´×Å΢ÈíÇÀÓû§£¬×Ô¼ºÈ´²»ÄÜ×öÈκÎÊÂÇé¡£ÒòΪ£¬Ò»µ©OracleÒ²·¢²¼Ç¨Òƹ¤¾ß£¬ÄÇôŷÃ˵ÄÉóÅú£¬ÊÇÌú¶¨Í¨²»¹ýµÄ£¡Ö»ÄÜ´óÉùµÄºôÓõ£ºÒ»¶¨»á±£³ÖMySQLµÄ¶ÀÁ¢¡£¿ÉÊÇ×î½ü¼¸ÄêOracleµÄһϵÁÐÊÕ¹ºÊÖ·¨È´ÈÃÈ˲»¸ÒÏàÐÅ¡£
΢ÈíÔòЦºÇºÇµÄ˵£º×ö×Ô¼ºµÄÇ¨ÒÆ¹¤¾ß£¬ÈÃOracleÈ¥×ż±°É£¡
Ïà¹ØÎĵµ£º
£±¡¢È·¶¨ÄãµÄ¼ÆËã»úÉÏ×°ÓÐoracleµÄ¿Í»§¶Ë£¬Èç¹ûûÓУ¬Çë°²×°oracle¿Í»§¶Ë
£²¡¢È·¶¨ÓÐÄãµÄoracle·þÎñÀïÓÐÄãÒªÐèÒª±¸·ÝµÄÊý¾Ý¿âµÄ·þÎñÃû¡£
£³¡¢ÖÆ×÷Ò»¸öÅú´¦ÀíÎļþ£¨oracleBackup.bat£©£¬¾ßÌå·½·¨£º´ò¿ª“¼Çʱ¾”£¬±£´æÎªoracleBackup.bat£¬
¡¡¡¡´Ëʱ±£´æµÄÎļþÀàÐÍÑ¡ÔñΪ“ËùÓÐÎļþ”¡£Îҵı£´æÄ¿Â ......
´´½¨ÁËÒ»oracleµÄ¶¨Ê±ÈÎÎñ£¬¶¨Ê±µÄ½«Ò»¸ö±íÖеļǼ²åÈëµ½ÁíÒ»¸ö±íÖУ¬²éѯµÄʱºò±íÖо¹È»Ã»Êý¾Ý£¬ÔÚpl/sqlÖв鿴½¨µÄÈÎÎñ·¢ÏÖfailuresµÄֵΪ3£¬ÄѵÀ½¨µÄ´æ´¢¹ý³ÌÓÐ´í£¿ÔËÐÐһϴ洢¹ý³ÌÊÔÊÔ°É£¬²éÊý¾Ý¿âÊ飬ִÐд洢¹ý³ÌÃüÁîÊÇ£ºcall procedure ¹ý³ÌÃû£»
Ö´ÐÐÒ»ÏÂÃüÁ²»¶Ô£¿ÔÙ´ÓÍøÉϲé°É£¬Ò»²é£¬oracleÖÐÖ´Ðд洢¹ý³ÌµÄ ......
Oracle µÄrownum ÔÀíºÍʹÓÃ
ÔÚOracle ÖУ¬Òª°´Ìض¨Ìõ¼þ²éѯǰNÌõ¼Ç¼£¬Óøörownum ¾Í¸ã¶¨ÁË¡£
select * from emp where rownum <= 5
¶øÇÒÊéÉÏÒ²¸æ½ë£¬²»ÄܶÔrownum ÓÃ">"£¬ÕâÒ²¾ÍÒâζ×Å£¬Èç¹ûÄãÏëÓÃ
select * from emp where rownum > 5
ÔòÊÇʧ°ÜµÄ¡£ÒªÖªµÀΪʲô»áʧ°Ü£¬ÔòÐèÒªÁ˽ârownum ±³ºóµÄ»úÖÆ£ ......
Á·Ï°:
drop table Employee;
create table Employee(
id number primary key,
  ......