C#Á¬½ÓOracle 10g
C#Á¬½ÓOracle 10g
ÎÄÕ³ö´¦£ºDIY²¿Âä(http://www.diybl.com/course/4_webprogram/asp.net/asp_netshl/200853/112441.html)
1¡¢¿ØÖÆÃæ°å->¹ÜÀí¹¤¾ß->Êý¾ÝÔ´(ODBC)->Ìí¼ÓÊý¾ÝÔ´->Ñ¡Ôñoracle ¿Í»§¶Ë
Data Source Name ¿ÉÒÔÈÎÒâÆðÃû£¬ÍƼöºÍSIDÒ»Ñù
Description ÃèÊö
TNS Service Name ÏÂÀ²Ëµ¥Öлá×Ô¶¯ÏÔʾ»·¾³±äÁ¿TNS_ADMINËùָĿ¼ÏµÄtnsnames.oraÎļþÖÐSERVICE_NAMEµÄÃû³Æ£¬Ò²¾ÍÊÇÒªÁ¬½ÓµÄSID
UserID ̞
2¡¢Test ConnectionÁ¬½Ó³É¹¦
C#
ÏîÄ¿->Ìí¼ÓÒýÓÃ->.NET->System.Data.OracleClient.dll £¨Õâ¸öDLLÔÚ×°ÍêDOTNET 1.1¾Í´æÔÚ£©
using System;
using System.Data;
using System.Windows.Forms;
using System.Data.OracleClient;
namespace Test
...{
/**//**//**//// <summary>
/// ¼ò½àÆڼ䣬ֱ½Ó½«ÊµÏÖдÔÚ¹¹Ô캯ÊýÖÐ
/// </summary>
public class Test
...{
public Test()
...{
//
// TODO: ÔÚ´Ë´¦Ìí¼Ó¹¹Ô캯ÊýÂß¼
//
string ConnectionString = "Data Source=orcl
; User Id=SCOTT; Password=scott"; //Á¬½Ó×Ö·û´®
OracleConnection conn = new OracleConnection(ConnectionString); //´´½¨Ò»¸öÐÂÁ¬½Ó
try
...{
&n
Ïà¹ØÎĵµ£º
ÔÚOracleÖн¨¿â£¬Í¨³£ÓÐÁ½ÖÖ·½·¨¡£Ò»ÊÇʹÓÃOracleµÄ½¨¿â¹¤
ÇÒDBCA£¬ÕâÊÇÒ»¸öͼÐνçÃ湤ÇÒ£¬Ê¹ÓÃÆðÀ´·½±ãÇÒºÜÈÝÒ×Àí½â£¬ÒòΪËüµÄ½çÃæÓѺá¢ÃÀ¹Û£¬¶øÇÒÌáʾҲ±È½ÏÆëÈ«¡£ÔÚ£×indowsϵͳÖУ¬Õâ¸ö¹¤¾ß¿ÉÒÔÔÚOracle³ÌÐò×éÖдò¿ª£¨”¿ªÊ¼”—“³ÌÐò”—“ Oracle OraDb10g_home1”&mdash ......
OracleϵÁУºÍ¼Æ¬µÄ´æ´¢
Ò»£ºÊ²Ã´ÊÇ´ó¶ÔÏ󣬴ó¶ÔÏó»ù±¾²Ù×÷£¿
²Î¼ûÎÒµÄBLOG£ºOracleϵÁУºLOB´ó¶ÔÏó´¦Àí
http://blog.csdn.net/qfs_v/archive/2008/05/21/2464599.aspx
¶þ£¬Í¼Æ¬µÄ´æ´¢»ò¶þ½øÖÆÎļþµÄ´æ´¢
1£¬ÏȲåÈëÆÕͨÊý¾Ý£¬Óöµ½´ó¶ÔÏóÁÐʹÓÃempty_blob()¹¹Ôì¿ÕµÄÖ¸Õë¡£
Àý× ......
FORALLÓï¾äµÄÒ»¸ö¹Ø¼üÐԸĽø£¬Ëü¿É´ó´ó¼ò»¯´úÂ룬²¢ÇÒ¶ÔÓÚÄÇЩҪÔÚPL/SQL³ÌÐòÖиüкܶàÐÐÊý¾ÝµÄ³ÌÐòÀ´Ëµ£¬Ëü¿ÉÏÔÖøÌá¸ßÆäÐÔÄÜ¡£
1:
ÓÃFORALLÀ´ÔöÇ¿DMLµÄ´¦ÀíÄÜÁ¦
OracleΪOracle8iÖеÄPL/SQLÒýÈëÁËÁ½¸öеÄÊý¾Ý²Ù×ÝÓïÑÔ£¨DML£©Óï¾ä£ºBULK COLLECTºÍFORALL¡£ÕâÁ½¸öÓï¾äÔÚPL/SQLÄÚ²¿½øÐÐÒ»ÖÖÊý×é´¦Àí
£»BULK COLLE ......
HWMÊÇoracleÖÐblockÓÐûÓÐʹÓõķֽçÏߣ¬Ëü»áËæ×ÅÊý¾ÝµÄinsert¶øÉÏÉý£¬µ«Ëü²¢²»»áËæÊý¾ÝµÄdelete¶øϽµ£¬Òò´ËÈ«±íɨÃèµÄʱ¼ä²¢²»ÒòÊý¾ÝµÄdelete¶ø¼õÉÙ£¬Ïà·´¿ÉÄÜÓÉÓÚ¿éÇå³ý·´¶øÈ«±íɨÃèʱ¼äÔö¼Ó£¬¿ÉÒÔÓÃÏÂÃæ·½·¨µÄÈÎÒ»Ò»ÖÖÀ´½µµÍHWM£º
µÚÒ»ÖÖ£ºshrink
ÊÊÓÃÓÚ10gÒÔºóµÄ°æ±¾£¬Ç°ÌáÊÇÕâ¸ö±í£¬Ë÷Òý£¬ÎﻯÊÓͼ»òÎﻯÊÓͼlogËùÔ ......