oracle ºÍMSSQLÓÐÄÄÐ©Çø±ð£¡ - .NET¼¼Êõ / C#
´ó¼Ò·¢±íÒ»ÏÂ×Ô¼ºµÄÒâ¼û°¡£¡
1 ¿ªÔ´ÐÔ²»Ò»Ñù
2 Êý¾Ý¿âÈÝÁ¿ÐÔÄܽç±ð²»Äܲ¢ÂÛ
3 ¹«Ë¾¹æÄ£ÍêÈ«²»Ò»Ñù
OracleĿǰÊǹØÏµÊý¾Ý¿âÖв¢·¢ÐÔÄÜ×îºÃµÄ£¬Ò²µÃµ½¹«ÖÚÈϿɡ£
Mysql³äÆäÁ¿¿ÉÒÔËã¸öÖÐÐÍÊý¾Ý¿â
oracleÊÇÃæÏò´óÖÐÐÍÆóÒµÓ¦ÓõÄÊý¾Ý¿âϵͳ£¬¾ßÓнϸߺͽÏÍêÉÆµÄÐÔÄÜ£¬µ«¶ÔÊý¾Ý¿â¹ÜÀíÔ±¾ßÓнϸߵÄÒªÇó¡£Ö§³Ö¶àÖÖ²Ù×÷ϵͳƽ̨¡£
sqlserverÊÇÃæÏòÖÐСÆóÒµµÄÊý¾Ý¿âϵͳ²úÆ·£¬¾ßÓкܺõÄÓû§½»»¥ÐԺ͹ÜÀí½çÃæ£¬¶ÔÊý¾Ý¿â¹ÜÀíÔ±ÒªÇó½ÏµÍ£¬ÇÒÒ×ÓÚѧϰ¡£Ä¿Ç°°æ±¾Îª2008£¬Ö»Ö§³Öwindowsƽ̨¡£
´Ó°²È«ÐÔÀ´½²£¬oracle±ÈmssqlÒª¸ß¡£¡£¡£²¢ÇÒÓи´ºÏÐÍÊý¾ÝÀàÐÍ
oracle±ÈsqlserverÇ¿´ó
oracle±ÈsqlserverÇ¿´ó
¸Ð¾õsql 2008ÒѾºÜ¿ÉÒÔÁË.Ìý˵һÏÂÃÀ¹úµÄÖÝµÄ¹ÉÆ±½»Ò×¾ÍÊÇÓõÄËü.Ö§³ÖÒ»ÏÂ!
ǰ¶Îʱ¼äʹÓùý£¬´óµÄÎÒ²»»á˵£¬¾Í˵˵Ó÷¨ÉϵÄһЩ²»Í¬°É£¬OracleûÓÐ×ÔÔöÁУ¬ÈÕÆÚ´æ´¢²»Í¬£¬»¹ÓоÍÊÇSQLÓï·¨Óе㲻һÑù£¬ÎÒ¾ÍÓõ½ÕâЩ£¬ºÇºÇ
Ïà¹ØÎÊ´ð£º
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
ÎÒÓÐÒ»¸öÀàËÆµÄxmlµÄ string£¬Ïëͨ¹ý±éÀúÔõô¸öxml Êä³öÎÒÏëÒªµÄelementµÄÖµ
xml Ϊ£º
<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
<RequestType>DISCOVER_XML_ME ......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......