C#»·¾³ÏÂÍùoracleÖеÄblob×ֶβåÈëÎļþ
Ìí¼ÓÒýÓÃ
using System.Data.OracleClient;
Ö÷ÒªÓõ½ÁËÁ½¸öÀà
System.Data.OracleClient.OracleConnection ±íʾһ¸öµ½Êý¾Ý¿âµÄÁ¬½Ó¡£´ËÀàÎÞ·¨¼Ì³Ð¡£
System.Data.OracleClient.OracleCommand ±íʾÕë¶ÔÊý¾Ý¿âÖ´ÐÐµÄ SQL Óï¾ä»ò´æ´¢¹ý³Ì¡£´ËÀàÎÞ·¨¼Ì³Ð¡£
m_pathΪÒѾ»ñÈ¡µÄÎļþÃû(full name)
±íFJ_SÖж¨ÒåÁËÈý¸ö×Ö¶ÎXM_ID(varchar(50)),XM_NAME(varchar(50),FJ_FILE(blob)
private bool InputRecordToOracle(string sFilePath
{
if (m_Path == null)
{
return false;
}
//»ñµÃÎļþÁ÷
System.IO.FileStream pFS = new System.IO.FileStream(m_Path, FileMode.Open, FileAccess.Read);
Byte[] pBuffer = new Byte[pFS.Length];//°ÑÎļþת³ÉByteÐͶþ½øÖÆÁ÷
pFS.Read(pBuffer, 0, pBuffer.Length);//°Ñ¶þ½øÖÆÁ÷¶ÁÈ뻺³åÇø
pFS.Close();
try
{
string sConnecStr = "Data Source=*;User ID=*;Password=*";
OracleConnection pConn = new OracleConnection(sConnecStr);
&n
Ïà¹ØÎĵµ£º
À䱸·ÝÊý¾Ý±ØÐëÊÇÊý¾Ý¿â²»ÔÚopen״̬Ï¡£ ÒÔϲ½Öè»á¸ø³öÏêϸµÄ¹ý³Ì£º
¡¡¡¡(1)£º ¹Ø±ÕDB £º shutdown immediate£»
¡¡¡¡(2)£ºcopy oradataĿ¼ÏµÄËùÓÐÎļþ£¬ °üÀ¨Êý¾ÝÎļþ£¬ ¿ØÖÆÎļþ£¬redo£¬µÈ£¬»¹ÐèÒªcopy ÃÜÂëÎļþ ÔÚĿ¼ora92Ï µÄdatabase ÖеÄpwd Îļþ.È«²¿copyµ½Ò»¸ö°²È«Ä¿Â¼ÖС£ÔÚsql ......
OracleµÄÓÅ»¯Æ÷ÓÐÁ½ÖÖÓÅ»¯·½Ê½(ÕûÀí), 2010-04-13
RBO·½Ê½£º»ùÓÚ¹æÔòµÄÓÅ»¯·½Ê½(Rule-Based Optimization£¬¼ò³ÆÎªRBO)
ÓÅ»¯Æ÷ÔÚ·ÖÎöSQLÓï¾äʱ,Ëù×ñѵÄÊÇOracleÄÚ²¿Ô¤¶¨µÄһЩ¹æÔò¡£±ÈÈçÎÒÃdz£¼ûµÄ£¬µ±Ò»¸öwhere×Ó¾äÖеÄÒ»ÁÐÓÐË÷Òýʱȥ×ßË÷Òý¡£
CBO·½Ê½£º»ùÓÚ´ú¼ÛµÄÓÅ»¯·½Ê½(Cost-Based Optimization£¬¼ò³ÆÎªCBO ......
ÔÚWeb¿ª·¢ÖУ¬´ÓÒ³Ãæ×¢ÈëµÄʱ¼äÒ»°ãΪStringÀàÐÍ£¬ÔõôȥºÍOracleÖеÄʱ¼ä½øÐбȽÏ
·½·¨£º
String Time£»
.......// Ò»¶Î´úÂë
¼ÙÉèTimeÎªÒ³Ãæ×¢ÈëStringÀàÐÍÊý¾Ý£¬Îª"2010-10-10 12:02:01"¡£
ÔÚдSQLÓ ......
¹Ù·½Îĵµ£ºhttp://tahiti.oracle.com/
metalink:http://metalink.oracle.com
itpub:www.itpub.com
TOM:asktom.oracle.com
oracle forum:http://forums.oracle.com/forums/main.jspa?categoryID=84
OTN:http://www.oracle.com/technology/index.html
www.oracle.com.cn
www.eygle.com
Oracle ERP
www.erp10 ......