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

Ôõô´Ó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 (
&


Ïà¹ØÎĵµ£º

ORACLE Ä£Äâ java SPLIT

CREATE OR REPLACE FUNCTION F_HPS_SPLIT
/*
 * ¹¦    ÄÜ: split.
 * ÊäÈë²ÎÊý: Liststr  string
 * ÊäÈë²ÎÊý: Sepe     index
 * ÊäÈë²ÎÊý: Sepe     separator. default is ','.
 * return sepeCount
 */
(
  ......

oracle »»ÐеĽâ¾ö°ì·¨

ÆäʵÕâ¸öºÜ¼òµ¥¾Í°²×°Èý¸ö°ü¾Í¿ÉÒÔÁË£¬·Ö±ðÊÇ£º
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- ......

×¥SQLÖ´ÐÐÓï¾äʱ¼äµÄ½Å±¾

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¶¨Ê±×÷ÒµµÄÉèÖ÷½·¨

 Èç¹ûÔÚSQL Server ÀïÐèÒª¶¨Ê±»òÕßÿ¸ôÒ»¶Îʱ¼äÖ´ÐÐij¸ö´æ´¢¹ý³Ì»ò3200×Ö·ûÒÔÄÚµÄSQLÓï¾äʱ, ¿ÉÒÔÓùÜÀí->SQL Server´úÀí->×÷ÒµÀ´ÊµÏÖ¡£
¡¡¡¡1¡¢¹ÜÀí->SQL Server´úÀí->×÷Òµ(°´Êó±êÓÒ¼ü)->н¨×÷Òµ
¡¡¡¡2¡¢Ð½¨×÷ÒµÊôÐÔ(³£¹æ)->Ãû³Æ[×Ô¶¨Òå±¾´Î×÷ÒµµÄÃû³Æ]->ÆôÓõķ½¿òÄÚÊǹ´ºÅ->
·ÖÀà´¦¿ ......

sql group by Óë havingµÄÓ÷¨

1. GROUP BY ÊÇ·Ö×é²éѯ, Ò»°ã GROUP BY ÊǺ;ۺϺ¯ÊýÅäºÏʹÓÃ
group by ÓÐÒ»¸öÔ­Ôò,¾ÍÊÇ select ºóÃæµÄËùÓÐÁÐÖÐ,ûÓÐʹÓþۺϺ¯ÊýµÄÁÐ,±ØÐë³öÏÖÔÚ group by ºóÃæ£¨ÖØÒª£©
ÀýÈç,ÓÐÈçÏÂÊý¾Ý¿â±í£º
A    B
1    abc
1    bcd
1    asdfg
 Èç¹ûÓÐÈ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ