΢Èí£º×ö×Ô¼ºµÄǨÒƹ¤¾ß£¬ÈÃ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È¥×ż±°É£¡
Ïà¹ØÎĵµ£º
Á·Ï°:
drop table Employee;
create table Employee(
id number primary key,
  ......
oracleÈÃid×Ô¶¯Ôö³¤£¨insertʱ²»ÓÃÊÖ¶¯²åÈëid£©µÄ°ì·¨£¬ÏñMysqlÖеÄauto_incrementÄÇÑù
´´½¨ÐòÁÐ
create sequence emp_seq
increment by 1
start with 1
nomaxvalue
nocycle
......
°ó¶¨±äÁ¿¾ÍÊÇÄܹ»Ìæ´úSQLÓï¾äÖг£Á¿µÄÌæ´ú±äÁ¿
×÷Óãº
°ó¶¨±äÁ¿Ö»ÊÇÆðµ½Õ¼Î»µÄ×÷Óã¬Í¬ÃûµÄ°ó¶¨±äÁ¿²¢²»Òâζ×ÅÔÚËüÃÇÊÇͬÑùµÄ£¬ÔÚ´«µÝʱҪ¿¼ÂǵÄÊÇ´«µÝµÄÖµÓë°ó¶¨±äÁ¿³öÏÖ˳ÐòµÄ¶Ô룬¶ø²»Êǰ󶨱ä Á¿µÄÃû³Æ¡£
°ó¶¨±äÁ¿ÊÇÔÚͨ³£Çé¿öÏÂÄÜÌáÉýЧÂÊ£¬·ÇÕý³£µÄÇé¿öÈçÏ£º
ÔÚ×Ö¶Î(°üÀ¨×ֶμ¯)½¨ÓÐË÷Òý£¬Ç ......
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 ......
µÚÒ»ÖÖÇé¿ö£ºÎÞ·µ»ØÖµ.
create or replace procedure test_a(param1 in varchar2,param2 in varchar2) as
begin
insert into test value(param1,param2);
&nb ......