Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 (
&


Ïà¹ØÎĵµ£º

Weblogic8.1Á¬½ÓSQL Server 2005(ת)

   weblogic8.1ûÓдøSQL Server 2005µÄJDBCÇý¶¯£¬ÐèҪȥ΢ÈíÍøÕ¾ÏÂÔØ¡£
    µØÖ·£ºhttp://msdn.microsoft.com/vstudio/express/sql/download/
    Æô¶¯   SQL Server Configuration manager£¬Õ¹¿ªSQL Server 2005
ÍøÂçÅäÖ㬵¥»÷“MSSQLSERVERµÄЭÒé&rdqu ......

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ÖÐobject_idº¯ÊýµÄÓ÷¨

SQLÖÐobject_idº¯ÊýµÄÓ÷¨ ÊÕ²Ø
 int object_id('objectname');
´Ë·½·¨·µ»ØÊý¾Ý¿â¶ÔÏó±êʶºÅ¡£
ÆäÖУ¬²ÎÊýobjectname ±íʾҪʹÓõĶÔÏ󣬯äÊý¾ÝÀàÐÍΪnchar»òchar£¨Èç¹ûΪchar£¬ÏµÍ³½«Æäת»»Îªnchar£©
·µ»ØÀàÐÍΪint£¬±íʾ¸Ã¶ÔÏóÔÚϵͳÖеıàºÅ¡£
±ÈÈ磺
use wf_timesheet
select object_id('usp_check_excess ......

Êý¾Ý¿â×é¼þ Hxj.Data £¨Ê®£© £¨Êä³ö×é¼þÖ´ÐеÄsql£©

Ç°ÃæÓÐTXÁôÑÔÎÊ·ÖÒ³µÄsqlÊÇÔõôÑùµÄ£¬¿´ÍêÕâÆªÄãÒ²¾ÍÖªµÀÁË¡£ ×é¼þ¿ÉÒÔÊä³öÖ´ÐеÄsql£¬·½±ã²é¿´sqlÉú³ÉµÄÓï¾äÊÇ·ñÓÐÎÊÌâ¡£ ͨ¹ý×¢²áʼþÀ´Êä³ösql DbSession.Default.RegisterSqlLogger(database_OnLog);
 
private string sql;
void database_OnLog(string logMsg)
{
//±£´æÖ´ÐеÄDbCommand (sqlÓï ......

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ºÅ