Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

΢Èí£º×ö×Ô¼ºµÄǨÒƹ¤¾ß£¬ÈÃ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µÄ»ù±¾ÖªÊ¶

Á·Ï°:
  drop  table  Employee;
create  table    Employee(
                 id         number    primary key,
    ......

oracle id ×ÔÔö

oracleÈÃid×Ô¶¯Ôö³¤£¨insertʱ²»ÓÃÊÖ¶¯²åÈëid£©µÄ°ì·¨£¬ÏñMysqlÖеÄauto_incrementÄÇÑù
´´½¨ÐòÁÐ  
  create   sequence   emp_seq  
  increment   by   1  
  start   with   1  
  nomaxvalue  
  nocycle  
  ......

OracleÖеİ󶨱äÁ¿

°ó¶¨±äÁ¿¾ÍÊÇÄܹ»Ìæ´úSQLÓï¾äÖг£Á¿µÄÌæ´ú±äÁ¿
×÷Óãº
    °ó¶¨±äÁ¿Ö»ÊÇÆðµ½Õ¼Î»µÄ×÷Óã¬Í¬ÃûµÄ°ó¶¨±äÁ¿²¢²»Òâζ×ÅÔÚËüÃÇÊÇͬÑùµÄ£¬ÔÚ´«µÝʱҪ¿¼ÂǵÄÊÇ´«µÝµÄÖµÓë°ó¶¨±äÁ¿³öÏÖ˳ÐòµÄ¶Ô룬¶ø²»Êǰ󶨱ä Á¿µÄÃû³Æ¡£
°ó¶¨±äÁ¿ÊÇÔÚͨ³£Çé¿öÏÂÄÜÌáÉýЧÂÊ£¬·ÇÕý³£µÄÇé¿öÈçÏ£º
ÔÚ×Ö¶Î(°üÀ¨×ֶμ¯)½¨ÓÐË÷Òý£¬Ç ......

oracle¿Í»§¶ËÓ¦´ðÎļþ

oracle.client 9.0.1.0.0
  ©À1-Oracle Programmer 9.0.1.0.0
  ©¦ ©ÀOracle Call Interface (OCI) 9.0.1.0.0
  ©¦ ©ÀObject Type Translator 9.0.1.0.0
  ©¦ ©¸Pro*C/C++ 9.0.1.0.0
  ©À2-Oracle Enterprise Manager Products 9.0.1.0.0
  ©¦ ©¸Oracle Enterprise Manager Cli ......

Javaµ÷ÓÃOracle´æ´¢¹ý³Ì


µÚÒ»ÖÖÇé¿ö£ºÎÞ·µ»ØÖµ.
      create or replace procedure test_a(param1 in varchar2,param2 in varchar2) as
       begin
            insert into test value(param1,param2);
  &nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ