Ôõô´Óoracleͨ¹ýodbc ºÍsqlµÃµ½mysql
oracleµÄodbcÍø¹Ø£¨gateway£©¼¸ºõÌṩһ¸öÎÞÏßµÄÊý¾ÝÕûºÏƽ̨£¬ÔÚoracleºÍÆäËüRDBMSÖ®¼ä£¬ÎÒÔÚÕâ²»Ïë˵ËüµÄ£¬²Ù×÷£¬ÏÞÖÆÒÔ¼°Ïà¹ØÐÔ£¬Ëü½â¾öÁËÒ»¸öСÎÊÌ⣬°ÑËü½¨Á¢ÆðÀ´ÄãÄÜ£¬ÀýÈ磬´´½¨Ò»¸ö database link ÔÚoracle ºÍoracleÖ®¼ä£¬±Ï¾¹£¬ÕâÑù²»ÊǺܺÃô£¬ÀýÈçÄãÄÜÔËÐÐÏÂÃæµÄsqlÓï¾ä£¬
select o.col1, m.col1 from oracle_tab
o, mysql_tab@mysql
m where o.col1=m.col1;
insert into oracle_tab
(select * from mysql_tab@mysql
);
Õâ¸ö¹«Ê¾£¬¾ÍÊÇÒªÓë´ó¼Ò·ÖÏí£¬ÏàͬµÄ·½·¨KARUN È¥Äê ÒѾΪsql server×ö¹ýÁË,Ò»´Ë¹ØÓÚÓÃmysql Á¬½ÓÆ÷odbc£¬ÔÚlinuxÉϽ¨Á¢oracle odbc Íø¹ØµÄÌáʾ¡£
ÐèÇó£º
ÎÒÒÑÔÚÎҵı¾±¾Éϰ²×°ºÃµÄËùÓеÄÅäÖÃÈ¥²âÊÔÕâ¸ö¹¦ÄÜ£¬²Ù×÷ϵͳÊÇUbuntu Intrepid Ibex 32bits¡£ÎÒ²»ÏëÏÝÈë°Ñthe MySQL Connector ODBC 5.1
°²×°µ½ÎÒ»úÆ÷ÉÏÕâÑùµÄÂé·³ÖÐÈ¥£¬ÒòΪÎÒ¸æËßÄ㣬¼ÙÈôÎÒ˵µÄ¶ÔµÄ»°£¬Intrepid »¹µÄiodbcµÄ°æ±¾¶Ôthe MySQL Connector ODBC 5.1
Ö§³ÖµÄ²»Ì«ºÃ£¬¶øÇÒ·µ»ØµÄÐÅÏ¢²»¹»Ã÷È·£¬Ì¹°×µÄ˵£¬ÎÒËù×öµÄ¾ÍÊǰѺï×Ó·ÅÔÚAugusto’s
±³ÉÏ¡£ËûÄܺܿì°ÑʲôÊÂÇé¶¼ÕûÀíºÃ£¬ÎÒÏëÎҵøÐлËüÁ½´Î£¬¾ÍÒòΪ¸ö¹«¸æ£¬ÎÒÔø¾Ò²°´ÕÕËûµÄ“Installing Oracle 11gR1 on Ubuntu 8.10 Intrepid Ibex”
ÎÄÕÂÈ¥°²×°oracle ²¿·Ö£¬ÏÖÔÚÈÃÎÒÃÇ˵˵ÐèÇó£¬ÄãÐèÒª°²×°ºÍÅäÖÃÏÂÃæµÄ×é¼þ£¬
Oracle database SE1, SE or EE; ÎÒ°²×°ÊÇ11.1.0.7 £¬10g Ò²Ó¦¸ÃûÎÊÌâ £¬Äã¿ÉÒÔÏÈ¿´¿´ORACLE_HOME/bin
,ËüÀïÃæÓиödg4odbc Îļþ£¬Äܲ»ÄÜÖ´ÐС£
MySQL 4.1, 5.0, 5.1 or 6.0.¸ù¾ÝÎĵµÕâ´Ë¶¼ÊÇConnector ODBC 5.1
. Ö§³ÖµÄ°æ±¾¡£
MySQL
Connector ODBC 5.1
. The Oracle Gateway for ODBC checks/relies on some features, such as the ODBC descriptor, that are not available in 3.51. You can check the associated documentation
and bug 32692
for some details aboutSQLSetDescRec
´´½¨Ò»¸ömysql Àý×ÓÊý¾Ý¿â£¬Óû§£¬Óë±í
ΪÁËÕâ¸öÀý×ÓÎÒÓÃmysql¿Í»§¶Ë£¬×öÁËÒ»¸ödatabase,user ºÍÒ»¸ö½ÐdemoµÄ±í¡£ÏÂÃæÊÇ´úÂ룺
$ mysql -uroot -p
create database demo character set latin1;
grant all privileges on demo.* to 'demo'@'localhost'
identified by 'demo' with grant option;
flush privileges;
exit;
$ mysql -udemo -pdemo -Ddemo
create table demo (
&
Ïà¹ØÎĵµ£º
Ò»£¬Ó²¼þÅäÖÃ×îµÍÒªÇó£º
32루X86£©£º
¸öÈËÈÏΪÖÁÉÙ1GÄڴ棨linux ÉÏ512M ¿ÉÒÔ£¬µ«Ì«¹ýÓÚÃãÇ¿ÁË£¬ÄÇÑùÈÝÒ×ËÀ»ú»ò¿¨×¡²»¶¯£¬»áÈÃÈË×¥¿ñµÄ;
windows 512M µÄ¿Ï¶¨²»ÐУ©
10GµÄ¿ÉÓô ......
¹«Ë¾Ê¹ÓÃlinux¿ª·¢»ú½øÐгÌÐò¿ª·¢Ê±£¬ÓÉÓÚ¿ª·¢ÓÃOracleÊý¾Ý¿âÊÇÓÉÈÕ·½Ìṩ£¬ËùÒÔ¾³£Ê¹ÓÃsqlplusÁ¬½Óµ½Ô¶³ÌÊý¾Ý¿âÉϽøÐпª·¢,ÀýÈ磺
sqlplus username/password@servicename
ÓÚÊÇÏ룬ÓÃÎÒµÄÁ½Ì¨µçÄÔË«»ú»¥ÁªÊÔÒ»ÊÔ£¬Ò²Íæ¸ö“Ô¶³ÌÁ¬½Ó”¡£ÊµÑéÈçÏ£º
Ê×ÏÈÔÚÎÒµĄ̈ʽ»úÉϰ²×°ÁËOracle9iµÄÊý¾Ý¿â¹ÜÀíϵͳ£¬ ......
SQLÖÐobject_idº¯ÊýµÄÓ÷¨ ÊÕ²Ø
int object_id('objectname');
´Ë·½·¨·µ»ØÊý¾Ý¿â¶ÔÏó±êʶºÅ¡£
ÆäÖУ¬²ÎÊýobjectname ±íʾҪʹÓõĶÔÏ󣬯äÊý¾ÝÀàÐÍΪnchar»òchar£¨Èç¹ûΪchar£¬ÏµÍ³½«Æäת»»Îªnchar£©
·µ»ØÀàÐÍΪint£¬±íʾ¸Ã¶ÔÏóÔÚϵͳÖеıàºÅ¡£
±ÈÈ磺
use wf_timesheet
select object_id('usp_check_excess ......
ʹÓÃTranact-SQL ±àд´úÂëÀ´´´½¨Ò»¸öÐÂ±í£º
USE [OnlineJudge]
GO
/****** Object: Table [dbo].[User1] Script Date: 05/17/2010 14:05:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[User2](/*notice convert the tablename*/
[num] [int]IDENTITY(1,1) NOT N ......
´´½¨´æ´¢¹ý³Ì֮ǰҪÏÈÓÃuseÓï¾äÉùÃ÷Òª½«´æ´¢¹ý³Ì´æ´¢ÔÚÄĸöÊý¾Ý¿âÖÐ. e.g use company; Ö´ÐÐÖ®.Ö®ºó¾Í¿ÉÒÔÉùÃ÷´æ´¢¹ý³ÌÁË. e.g create procedure *** @id varchar(50) , @name int output as select @name=name from table where id=@id È»ºó¿ÉÒÔÓÃalter¶Ô´æ´¢¹ý³Ì½øÐÐÐÞ¸Ä. declare¿ÉÒÔÉùÃ÷Ò»¸ö±äÁ¿ ÓÃset¶Ô±ä ......