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
Ïà¹ØÎĵµ£º
1¡¢µÇ¼·½·¨:£ºsys or systemµÇ¼
Õ˺ţºsystem
ÃÜÂ룺system as sysdba---------¡·ÃÜÂë+as sysdba
conn system/password as sysdba
ʹÓÃÃüÁ
sql>alter user scott account unlock;
sql> commit;
Í ......
OracleµÄÓÅ»¯Æ÷ÓÐÁ½ÖÖÓÅ»¯·½Ê½(ÕûÀí), 2010-04-13
RBO·½Ê½£º»ùÓÚ¹æÔòµÄÓÅ»¯·½Ê½(Rule-Based Optimization£¬¼ò³ÆÎªRBO)
ÓÅ»¯Æ÷ÔÚ·ÖÎöSQLÓï¾äʱ,Ëù×ñѵÄÊÇOracleÄÚ²¿Ô¤¶¨µÄһЩ¹æÔò¡£±ÈÈçÎÒÃdz£¼ûµÄ£¬µ±Ò»¸öwhere×Ó¾äÖеÄÒ»ÁÐÓÐË÷Òýʱȥ×ßË÷Òý¡£
CBO·½Ê½£º»ùÓÚ´ú¼ÛµÄÓÅ»¯·½Ê½(Cost-Based Optimization£¬¼ò³ÆÎªCBO ......
(Oracle£©rownumÓ÷¨Ïê½â
2008-08-06 15:41
¶ÔÓÚrownumÀ´ËµËüÊÇoracleϵͳ˳Ðò·ÖÅäΪ´Ó²éѯ·µ»ØµÄÐеıàºÅ£¬·µ»ØµÄµÚÒ»ÐзÖÅäµÄÊÇ1£¬µÚ¶þÐÐÊÇ2£¬ÒÀ´ËÀàÍÆ£¬Õâ¸öα×ֶοÉÒÔÓÃÓÚÏÞÖÆ²éѯ·µ»ØµÄ×ÜÐÐÊý£¬ÇÒrownum²»ÄÜÒÔÈκαíµÄÃû³Æ×÷Ϊǰ׺¡£
(1) rownum ¶ÔÓÚµÈÓÚijֵµÄ²éѯÌõ¼þ
Èç¹ûÏ£ÍûÕÒµ½Ñ§Éú±íÖеÚÒ»ÌõѧÉúµÄÐÅÏ¢£¬¿É ......
Oracle
Ë÷Òý¼¼ÊõµÄÓ¦ÓÃÓëÆÊÎö
×î
½üÕâ¶Îʱ¼ä£¬×ÜÊÇÏëдһЩÓйØÐÔÄܵ÷ÓŵÄÎÄÕ¡£µ«ÊÇ¿àÓÚûÓÐÒ»¸öʵ¼ÊµÄ°¸Àý£¬±¾ÈËÓÖ²»Ô¸¿Õ̸ÀíÂÛ£¬ÒòΪÕâЩÀíÂÛËæ±ãÔÚÍøÉϾÍÄÜÕÒµ½£¬¶øÇÒ»ù±¾ÉÏǧƪһÂÉ£¬
ÒòΪÀíÂÛÉϵÄÄÇЩ¶«Î÷¾ÍÄÇô¶à£¬ÔÙÔõô½²Ò²²»ÈçÒ»¸öʵ¼Ê°¸ÀýÉú¶¯¡£»¹ºÃÉÏÌì²»¸ºÓÐÐÄÈË£¬Ç°Ð©ÌìÈÃÎÒÅöµ½ÁËÒ»¸öʵ¼ÊµÄ°¸Àý¡£Õâ¸ö ......
¹Ù·½Îĵµ£º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 ......