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

C#¿ª·¢oracleµÄÎÊÌâ

±¾²ËÄñÔÚÁ·Ï°Ê¹ÓÃvs2005¿ª·¢oracle10gÊý¾Ý¿âʱ£¬³öÏÖÏÂÃæµÄ´íÎ󣬴Óû½Ó´¥¹ýorcale£¬Ï£Íû¸÷λ´óÏÀ°ïСµÜ½â´ðÒɻ󡫡«Ð»Ð»£¡


µ±"select * from companyinform"ȱÉÙ¡°;¡±Ê±£¬´íÎóÌáʾÈçÏÂͼ£º



PS£ºoracleÊý¾Ý¿âºÍvs2005¶¼×°ÔÚͬһ·þÎñÆ÷ÉÏ£¬·þÎñÆ÷win2003SP2
Ï£ÍûºÃÐÄÈ˰ïÐÂÊÖÏ¡«¡«

select * from dbo.companyinform , oracleÀï±íÇ°Ãæ¶¼ÒªÐ´ÉÏËùÓÐÕߵġ£ ²»Ò»¶¨ÊÇdbo,Äã¿´¿´Ó¦¸ÃÊÇʲô¾Íдʲô¡£

Ã²ËÆÃ»ÓÐÕâ¸ö±í ¡£¡£¡£

sqloda.Fill(xxx,xxx)
ΪʲôÄãÒªÌîµÚ¶þ¸ö²ÎÊý£¿ Ö»ÓÐdatasetÀïÃæÓÐÃûΪxxxµÄtableʱ²ÅÄÜÕâÑùÓðÉ

×¢ÒâÄãµÄconnStringÖеÄÕË»§ÊÇ·ñ¾ßÓзÃÎʴ˱íµÄȨÏÞ

È¥µô";",ÔÚ²éѯÓï¾äµÄ±íÃûǰ£¬¼ÓÉÏÃüÃû¿Õ¼ä°É...
ÒýÓÃ
select * from dbo.companyinform  , oracleÀï±íÇ°Ãæ¶¼ÒªÐ´ÉÏËùÓÐÕߵġ£ ²»Ò»¶¨ÊÇdbo,Äã¿´¿´Ó¦¸ÃÊÇʲô¾Íдʲô¡£


µÚ¶þÕÅͼµÄ´úÂëÊǶԵģ¬×Ô¼º¼ì²éÊý¾Ý¿â£¬¿´±íÃû¶Ô²»¶Ô£¬¿´ÏÂÄãµÇ½µÄÕʺÅÏÂÃæÓÐûÓÐÕâ¸ö±í

ÒýÓÃ
È¥µô";",ÔÚ²éѯÓï¾äµÄ±íÃûǰ£¬¼ÓÉÏÃüÃû¿Õ¼ä°É...
ÒýÓà 2 Â¥ kyoybs µÄ»Ø¸´:select * from dbo.companyinform  , oracleÀï±íÇ°Ãæ¶¼ÒªÐ´ÉÏËùÓÐÕߵġ£ ²»Ò»¶¨ÊÇdbo,Äã¿´¿´Ó¦¸ÃÊÇʲô¾Íдʲô¡£


Ê×ÏȸÐл¸÷λµÄ½â´ð£¬µ«ÊÇ»¹ÊÇû½â¾ö¡£oracleÊý¾Ý¿âµÄÁ¬½Ó×Ö·û´®Îª£º

connstring = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=JSC)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=WebServiceTest)));User Id=wsdb;Password=ws


Ïà¹ØÎÊ´ð£º

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

OracleµÄblob×Ö¶ÎÎÊÌâ - Oracle / ¿ª·¢

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......

server 2000Êý¾Ý×ªÒÆµ½oracle - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔ­À´oracleÀïµÄÔ­ÓеÄÊý¾Ý¿â,Ö»ÄÜн¨

ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......

±éÀúÒ»¸öxml²¢Êä³öÖ¸¶¨½ÚµãµÄÖµ - .NET¼¼Êõ / C#

ÎÒÓÐÒ»¸öÀàËÆµÄxmlµÄ string£¬Ïëͨ¹ý±éÀúÔõô¸öxml Êä³öÎÒÏëÒªµÄelementµÄÖµ
xml Ϊ£º
<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
  <RequestType>DISCOVER_XML_ME ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ