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

¹ØÓÚC# ORACLE ÎÊÌâ - .NET¼¼Êõ / C#

ÇëÎÊ ÔÚC#ÖÐ ¿ÉÒÔÖ±½ÓÓà insert into table (column1,cloumn2,....) values (values1,values2,....)²åÈëORACLE Êý¾Ý¿âÂð``` update ͬÑù¿ÉÒÔÂ𣿣¿
û°ì·¨``ÒÔǰûÓùý`û½Ó´¥¹ý`ûѧ¹ý``ÏÖÔÚÊÇʼ±ÂíÐÐÌÁÙʱ±§·ð½ÅÀ²``¸÷λ¸ßÊÖÖªµÀµÄ˵ÏÂ
¾ßÌåÔõôÑùÄØ``¿ÉÒÔ·¢Ò»Ð©¸ñʽ³öÀ´Âð£¿

ÓÐÈËÂð£¿

T-SQLÓï¾ä»ù±¾¶¼ÊÇͨÓõģ¬
µ«ÄãҪ˵Çå³þµØÎÊÌ⣬
ÄãÕâ¸öÎʵúÜÄ£ºý£¡

.NET³ÌÐòÁ¬½ÓORACLEÊÇ¿ÉÒԵģ¬
²Ù×÷Êý¾Ý¸úÁ¬½ÓSQL SERVERÊÇÒ»ÑùµÄ¡£

T-SQLÓï¾ä»ù±¾¶¼ÊÇͨÓÃµÄ Ã»ÓÐʲô̫´óµÄÇø±ð

SQL code:

sql = "INSERT INTO ticket(ticketnum,ticketnumext,subject,comments,datetime,domain,site,sector,channel,creatorteam,destinationteam,language,"
+"creator,skill,treatingagent,status,type,customer,dossiernum,callednum) VALUES (ticket_uid.nextval, '" +
ticNumExtBox.Text + "','" +
subjectBox.Text + "','" +
commentBox.Text + "','"+
dateTimePicker1.Value + "','" +
domainBox.Text + "','" +
siteBox.Text + "','" +
sectorBox.Text + "','" +
channelCom.Text + "','" +
cTBox.Text + "',


Ïà¹ØÎÊ´ð£º

OracleÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

sqlССµÄÒÉÎÊ - .NET¼¼Êõ / C#

¿ÉÄÜÒòΪ¹¤×÷µÄÔ­Òò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......

oracle²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracle ......

Ϊʲôxml²»ÄÜÏÔʾ°¢À­²®ÎÄ - C/C++ / C++ ÓïÑÔ

ΪʲôÎҵijÌÐòµ÷ÓÃXMLÅäÖÃÎļþÖеİ¢À­²®ÎÄÏÔʾ²»³öÀ´£¿ÆäËûµÄÓïÖÖ¶¼¿ÉÒÔ£¬ÈçÖÐÎÄ£¬Ó¢ÎÄ£¬µÂÎͼ¿É¡£
ÎÒ½«XMLµÄ±àÂë¸ÄΪutf-8ºÍunicodeµÄµ½µÃ½á¹û¶¼Ò»Ñù.
°¢À­²®ÎĵÄ×Ö¿âÄãÓÐô£¿

ÓÐ,ÎÒµÄEXEÊÇ·ÅÔÚpc»úÉÏÖ´Ðе ......

oracle 10g data guard - Oracle / »ù´¡ºÍ¹ÜÀí

×öÍædata guard ºó
ÔÚPrimary·þÎñÆ÷ Ö´ÐР
SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#;
 SEQUENCE# APP
---------- ---
  13 NO
  13 YES ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ