C#´¦Àíoracle lobµÄÀý×Ó
protected void BindData1()
{
OracleConnection orcn = new OracleConnection("User ID=wesoftwcp; Password=wesoft; Data Source=oradb");
orcn.Open();
string MyData = "";
StreamReader rs = new StreamReader(@"c:\1.txt");
MyData = rs.ReadToEnd();
rs.Close();
//OracleConnection orcn = new OracleConnection("User ID=wesoftwcp; Password=wesoft; Data Source=oradb");
//orcn.Open();
OracleType lobtype = OracleType.Clob; //Èç¹ûÊÇblobÕâÀï¸Ä³ÉOracleType.blob
string CreateTempBlob = "DECLARE A " + lobtype + "; " +
"BEGIN " +
"DBMS_LOB.CREATETEMPORARY(A, FALSE); " +
":LOC := A; " +
"END;";
OracleTransaction transaction = orcn.BeginTransaction();
OracleParameter[] param = new OracleParameter[1];
param[0] = new OracleParameter("LOC", OracleType.Clob);
//OracleHelper.CacheParameter(CreateTempBlob,param);
OracleCommand cmdTemp = new OracleCommand(CreateTempBlob, orcn);
param[0].Direction = ParameterDirection.Output;
//OracleHelper.ExecuteNonQuery(transaction
Ïà¹ØÎĵµ£º
ÔÚORACLE8Öж¨ÒåÁË£º±êÁ¿(Scalar)¡¢¸´ºÏ(COMPOSITE)¡¢ÒýÓÃ(REFERENCE)ºÍLOBËÄÖÖÊý¾ÝÀàÐÍ¡£
£¨Ò»£©±êÁ¿(Scalar)
±êÁ¿ÀàÐÍÓëÊý¾Ý¿âµÄÁÐËùʹÓõÄÀàÐÍÏàͬ£¬´ËÍâËü»¹ÓÐһЩÀ©Õ¹¡£
ËüÓÖ·ÖΪÆß¸ö×飺Êý×Ö¡¢×Ö·û¡¢ÐС¢ÈÕÆÚ¡¢Ðбêʶ¡¢²¼¶ûºÍ¿ÉÐÅ¡£
¢ÙÊý×Ö
¡¡
ÓÐÈ ......
ʹÓÃnulls first »òÕßnulls last Óï·¨
Nulls firstºÍnulls lastÊÇOracle Order byÖ§³ÖµÄÓï·¨
Èç¹ûOrder by ÖÐÖ¸¶¨Á˱í´ïʽNulls firstÔò±íʾnullÖµµÄ¼Ç¼½«ÅÅÔÚ×îǰ(²»¹ÜÊÇasc »¹ÊÇ desc)
Èç¹ûOrder by ÖÐÖ¸¶¨Á˱í´ïʽNulls lastÔò±íʾnullÖµµÄ¼Ç¼½«ÅÅÔÚ×îºó (²»¹ÜÊÇasc »¹ÊÇ desc)
ʹÓÃÓï·¨ÈçÏ£º
--½«nulls ......
oracle¶ÔÊ±ÇøµÄÖ§³Ö±È½ÏÍêÃÀÁË£¬ÓÐtimestamp with time zoneºÍtimestamp with local time zoneÁ½ÖÖÊý¾ÝÀàÐÍ¡£Ëùνtimestamp with time zone£¬Ò²¾ÍÊǰÑÊ±ÇøÐÅÏ¢±£´æÔÚÁÐÊý¾ÝÖУ¬¶øtimestamp with local time zone£¬»á½«Óû§ÊäÈëµÄʱ¼äת»»ÎªÊý¾Ý¿â·þÎñÆ÷ËùÔÚÊ±ÇøµÄʱ¼ä£¬±£´æÔÚÁÐÖУ¬ÕâÑùÄÜÉÔÉÔ¼õÉÙÒ»µã±£´æµÄÊý¾ÝÁ¿¡£ÒòΪt ......
SqLite.netµÄdllΪSystem.Data.SQLite.dll£¬ÕâÖÖdll·ÖΪ32λ¡¢64λºÍÊÊÓÃÓÚcompactframeworkÈýÖÖ£¬ÔÚÒýÓÃʱҪעÒ⣬ѡÔñÕýÈ·µÄdll¡£
½«Òª±£´æÍ¼Æ¬µÄ×Ö¶ÎÀàÐÍÉèΪblob¡£´úÂëÈçÏ£º
private void savePicture£¨£©
{
using (SQLiteConnection cnn = new SQLiteConnection(dbPath))
......