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


Ïà¹ØÎÊ´ð£º

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

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

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

ÇóÖú£ºC´úÂë¸Äд³ÉVB´úÂë - VB / »ù´¡Àà

Ë­ÄܰïÎÒ°ÑÏÂÃæÕâЩ´úÂë¸Ä³ÉVBÐÎʽµÄ£¬¶àлÁË£¬¼±ÓÃ~~
#include "stdlib.h"
#include "math.h"
#include "stdio.h"
float objfx(float x[]);
void constraint(float x[],float g ......

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