Ôõô´Ó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 (
&
Ïà¹ØÎĵµ£º
CREATE OR REPLACE FUNCTION F_HPS_SPLIT
/*
* ¹¦ ÄÜ: split.
* ÊäÈë²ÎÊý: Liststr string
* ÊäÈë²ÎÊý: Sepe index
* ÊäÈë²ÎÊý: Sepe separator. default is ','.
* return sepeCount
*/
(
......
ÆäʵÕâ¸öºÜ¼òµ¥¾Í°²×°Èý¸ö°ü¾Í¿ÉÒÔÁË£¬·Ö±ðÊÇ£º
IO-Tty-1.07.tar.gz£¬Term-ReadLine-Gnu-1.16.tar.gz£¬ uniread-1.01.tar.gz¡£
ÕâÈý¸ö°üÔÚÎҵĿռäÀï¶¼ÓÐ http://fwx515354.download.csdn.net/
½âѹ
tar -zxvf IO-Tty-1.07.tar.gz
tar -zxvf Term- ......
select sql_text, spid, v$session.program, process
from v$sqltext, v$session, v$process
where v$sqltext.address = v$session.sql_address
and v$sqltext.hash_value = v$session.sql_hash_value
and v$session.paddr = v$process.addr
and v$process.spid in (4335);
×¢Ò ......
Èç¹ûÔÚSQL Server ÀïÐèÒª¶¨Ê±»òÕßÿ¸ôÒ»¶Îʱ¼äÖ´ÐÐij¸ö´æ´¢¹ý³Ì»ò3200×Ö·ûÒÔÄÚµÄSQLÓï¾äʱ, ¿ÉÒÔÓùÜÀí->SQL Server´úÀí->×÷ÒµÀ´ÊµÏÖ¡£
¡¡¡¡1¡¢¹ÜÀí->SQL Server´úÀí->×÷Òµ(°´Êó±êÓÒ¼ü)->н¨×÷Òµ
¡¡¡¡2¡¢Ð½¨×÷ÒµÊôÐÔ(³£¹æ)->Ãû³Æ[×Ô¶¨Òå±¾´Î×÷ÒµµÄÃû³Æ]->ÆôÓõķ½¿òÄÚÊǹ´ºÅ->
·ÖÀà´¦¿ ......
1. GROUP BY ÊÇ·Ö×é²éѯ, Ò»°ã GROUP BY ÊǺ;ۺϺ¯ÊýÅäºÏʹÓÃ
group by ÓÐÒ»¸öÔÔò,¾ÍÊÇ select ºóÃæµÄËùÓÐÁÐÖÐ,ûÓÐʹÓþۺϺ¯ÊýµÄÁÐ,±ØÐë³öÏÖÔÚ group by ºóÃæ£¨ÖØÒª£©
ÀýÈç,ÓÐÈçÏÂÊý¾Ý¿â±í£º
A B
1 abc
1 bcd
1 asdfg
Èç¹ûÓÐÈ ......