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

C# Á¬½ÓOracleÊý¾Ý¿â


C#Á¬½ÓOracleÊý¾Ý¿â×Ö·û´®
http://developer.51cto.com
 2009-08-20 17:55  ØýÃû  °Ù¶È¿Õ¼ä  ÎÒÒªÆÀÂÛ(
0
)
C#Á¬½ÓOracleÊý¾Ý¿âÒÔ¼°C#Á¬½ÓOracleÊý¾Ý¿â×Ö·û´®µÈÄÚÈݽ«ÔÚ±¾ÎÄÖÐÕ¹ÏÖ£¬Ï£Íû±¾ÎÄÄܶԴó¼ÒÁ˽âC#Á¬½ÓÊý¾Ý¿âÓÐËù°ïÖú¡£
C#Á¬½ÓOracleÊý¾Ý¿â×Ö·û´®£¨²éѯÊý¾Ý£©
using
 System;  
using
 System.Collections.Generic;  
using
 System.ComponentModel  
using
 System.Data.OracleClient;;
//ÕâÐкÍÏÂÒ»Ðж¼ÒªÏÈÔÚÒýÓÃÖÐÌî¼Ósystem.data.oracleclient
 
using
 System.Data;  
using
 System.Drawing;  
using
 System.Text;  
using
 System.Windows.Forms;  
 
namespace
 WindowsApplication1  
{  
    
public
 partial 
class
 Form1 : Form  
    {  
        
public
 Form1()  
        {  
            InitializeComponent();  
        }  
          
        
private
 
void
 button1_Click(
object
 sender, EventArgs e)  
        {
 
            #region ´Óregionµ½endregionÊÇÊÖ¹¤Ð´µÄ¡£±ðµÄ¶¼ÊÇϵͳ×Ô¶¯Éú³ÉµÄ
 
            
string
 constring = 
"data source=wzd;user=wzd;password=wzd;"
;
//¶¨ÒåÁ¬½ÓÊý¾Ý¿âµÄ×Ö·û´®
 
            OracleConnection conn = 
new
 OracleConnection(constring);
//½øÐÐÁ¬½Ó
 
        &


Ïà¹ØÎĵµ£º

Oracleɾ³ýÖØ¸´¼Ç¼

Oracleɾ³ýÖØ¸´¼Ç¼µÄ×îºÃµÄ·½·¨£º
DELETE from EMP E WHERE E.ROWID > (SELECT MIN(y.ROWID)
from EMP y
WHERE y.EMPNO = E.EMPNO )
1¡¢×Ó²éѯÕÒ³öijԱ¹¤×îµÍµÄROWID£¨¿Ï¶¨Ö»ÓÐÒ»¸ö£©£¬ÆäËü´óÓÚÕâÌõ¼Ç¼ROWIDµÄ£¬È«²¿É¾³ý¡£
2¡¢OracleÖÐʹÓÃROWIDɾ³ýÖØ¸´¼Ç¼×î¿ì,ÒòΪRowid¶ÔÓ¦ÕâÌõ¼Ç¼ÔÚ´ÅÅÌÉϵÄλÖÃ
ÃæÊÔ£º ......

OracleÊý¾Ý¿âÓαêʹÓôóÈ«

SQLÊÇÓÃÓÚ·ÃÎÊORACLEÊý¾Ý¿âµÄÓïÑÔ£¬PL/SQLÀ©Õ¹ºÍ¼ÓÇ¿ÁËSQLµÄ¹¦ÄÜ£¬Ëü ͬʱÒýÈëÁ˸üÇ¿µÄ³ÌÐòÂß¼­¡£ PL/SQLÖ§³ÖDMLÃüÁîºÍSQLµÄÊÂÎñ¿ØÖÆÓï¾ä¡£DDLÔÚPL/SQLÖв»±»Ö§³Ö£¬Õâ¾ÍÒâζ×÷ÔÚPL/SQL³ÌÐò¿éÖв»ÄÜ´´½¨±í»òÆäËûÈκζÔÏ󡣽Ϻà µÄPL/SQL³ÌÐòÉè¼ÆÊÇÔÚPL/SQL¿éÖÐʹÓÃÏóDBMS_SQLÕâÑùµÄÄÚ½¨°ü»òÖ´ÐÐEXECUTE IMMEDIATEÃüÁÁ¢¶¯Ì ......

c# ÑéÖ¤Âë×é¼þ ¿Évb£¬asp£¬netµ÷ÓÃ

      ½ñÌ칫˾ҪÇóÓÃC#д¸öÑéÖ¤Âë×é¼þ£¬ÈÃasp¿ÉÒÔµ÷Óã¬ÔÚÍøÉÏÕÒÁËÒ»¶Ñ×ÊÁÏ£¬ÖÕÓÚ¸øÎÒ¸ø¸ã³öÀ´ÁË£¬ÒòΪ±¾È˵ÚÒ»´Îд×é¼þ£¬Ò²ÊǵÚÒ»´Î·¢±íÎÄÕ£¬ËùÓпÉÄÜ˵µÄ²»ÊǺܺ㬴ó¼ÒÇë¼ûÁ¡£
      csdnÉÏÓÐÕâôƪÎÄÕ£¬Ïëѧϰд×é¼þµÄ¿ÉÒÔÈ¥¿´¿´£ºhttp://blog.csdn.net/KimmKi ......

ÔÚlinuxÖÐʹÓÃcrontabʵÏÖ¶ÔoracleµÄ¶¨Ê±±¸·Ý

¼ÙÉèÊý¾Ý¿âµÄÓµÓÐÕßΪoracle£¬Êý¾Ý¿âµÄÓû§Îªscott£¬Æä¿ÚÁîΪtrigger£¬
OracleÊý¾Ý¿âµÄ²ÎÊý$ORACLE_HOMEΪ/usr/oracle£¬$ORACLE_SIDΪoracle1£¬ÔòʵÏÖ²½ÖèÈçÏ£º
1¡¢½¨Á¢ÊµÏÖ±¸·ÝµÄshell
ÔÚ/usr/oracleÖÐÓÃviÃüÁÁ¢Îļþbackup.sh£¬ÆäÄÚÈÝΪ:
ORACLE_HOME=/usr/oracle; <br>export ORACLE_HOME;
ORACLE_SID= ......

MS SQL 2005Á´½Ó·þÎñÆ÷Á¬½ÓÔ¶³ÌORACLEÈ«¹ý³Ì

µÚÒ»²½:ÏÂÔØ°²×°Oracle 10g Release 2 ¿Í»§¶ËÈí¼þ,ÏÂÔØÁ¬½ÓÊÇ:
http://download.oracle.com/otn/nt/oracle10g/10201/10201_database_win32.zip
ÏÂÔØºó°²×°
 
 
 
µÚ¶þ²½:ÏÂÔØ°²×°Oracle ODAC,ÏÂÔØÁ¬½ÓÊÇ:
http://download.oracle.com/otn/other/ole-oo4o/ODAC1020221.exe
 
µÚÈý²½: ÖØÆôMS SQ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ