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
Ïà¹ØÎĵµ£º
ʹÓÃ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 ......
ÔÚFedora 10Éϰ²×°Oracle£¨10.2.0£©
ĬÈϵÄϵͳ²ÎÊýÏ£¬ÔÚFedora 10ÉÏÎÞ·¨°²×°Oracle£¬ÐèÒª½øÐÐÏÂÁÐÈô¸É´¦Àí£º
1. Ñé֤ϵͳҪÇó
ÒªÑé֤ϵͳÊÇ·ñÂú×ã Oracle 10g Êý¾Ý¿âµÄ×îµÍÒªÇó£¬ÒÔ root Óû§Éí·ÝµÇ¼²¢ÔËÐÐÒÔÏÂÃüÁî¡£
Òª²é¿´¿ÉÓà RAM ºÍ½»»»¿Õ¼ä´óС£¬ÔËÐÐÒÔÏÂà ......
ѧϰOracleʱ£¬Äã¿ÉÄÜ»áÓöµ½OracleÓû§±í¿Õ¼äÎÊÌ⣬ÕâÀォ½éÉÜOracleÓû§±í¿Õ¼äÎÊÌâµÄ½â¾ö·½·¨£¬ÔÚÕâÀïÄóöÀ´ºÍ´ó¼Ò·ÖÏíһϡ£Æäʵ¾ÍÊÇÔÚÒÑÓеÄÊý¾Ý¿âʵÀýÉÏ´´½¨Ò»¸öеÄÕʺţ¬·ÃÎÊһЩÐÂµÄ±í¡£
²Ù×÷²½ÖèÈçÏ£º
1¡¢µÇ¼linux£¬ÒÔOracleÓû§µÇ¼£¨Èç¹ûÊÇrootÓû§µÇ¼µÄ£¬µÇ¼ºóÓÃsu-oracleÃüÁîÇл»³ÉoracleÓû§£©
2¡¢ÒÔsy ......
1£¬ÔÚweb·þÎñÆ÷Éϰ²×°OracleÊý¾Ý¿â¿Í»§¶Ë£¬ÕâÊÇÁ¬½ÓOracleÊý¾Ý¿âµÄ»ù´¡£¨µ«£¬²»Ò»¶¨ÊDZØÐëµÄ£©¡£
2£¬ÔÚ¿Í»§¶ËµÄNet Manager ÖнøÐÐÅäÖ÷þÎñµÄÃû³Æ£¬ÅäÖÃÈçͼ£¨ÕâÒ»µã·Ç³£µÄÖØÒªÒÔºóµÄÁ´½ÓÈ«¶¼ÔÚÕâ¸ö·þÎñÃû³ÆµÄ»ù´¡ÉϽøÐеģ©
3£¬ASPÁ´½Ó·þÎñµÄÁ´½Ó×Ö·û´®ºÍ·½·¨ÈçÏ£º
<%
connstr= "Provider=MSDAORA.1;Password=***; ......
Anders Hejlsberg(°²µÂ˹-º£É²©¸ñ) ×øÔÚ×Ô¼ºµÄ°ì¹«ÊÒ£¬Ë«ÑÛÖ±Ö±µÄ¶¢×Åǰ·½¡£ËûÒª×öÒ»¸ö¾ö¶¨£¬¾ö¶¨×Ô¼ºÎ´À´µÄÃüÔ˺ÍÀíÏë¡£ÕâÊÇ1996ÄêÒ»¸öÆÕͨµÄÏÂÎ磬¼¸¸öСʱǰ£¬Ëû¸ÕÓë±È¶û-¸Ç´Ä½áÊøÁËÒ»´ÎÓä¿ìµÄÎç²Í£¬Í¬ÎªÈí¼þ½çµÄ¾«Ó¢£¬ËûÃÇÏà̸Éõ»¶£¬¸Ç´Ä¸øËû¿ª³öÈý°ÙÍòÒÔÉϵÄÄêнºÍÊýÍò¹ÉµÄ΢Èí¹ÉƱ¡£ÕâÊÇÒ»¸öÓÕÈË ......