Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

C# ¶ÁÈ¡ºÍдÈëoracleµÄblob×ֶεķ½·¨

 //ÏòÊý¾Ý¿âÖÐдÈë
        private void button1_Click(object sender, EventArgs e)
        {
            oracleConnection1.Open();
          
            OracleCommand cmd = new OracleCommand("UPDATE TEST SET F2 =:blob where F1=:sn ", oracleConnection1);
           
            cmd.Parameters.Add(new OracleParameter("blob",OracleType.Blob));
              cmd.Parameters.Add(new OracleParameter("sn",OracleType.Int32));
             FileInfo fi = new FileInfo("c:\\dos.doc");
             FileStream fs = fi.OpenRead();
             byte[] MyData = new byte[fs.Length];
             fs.Read(MyData, 0, System.Convert.ToInt32(fs.Length));
             fs.Close();
            cmd.Parameters["blob"].Value = MyData;
            cmd.Parameters["sn"].Value = 1;
            try
            {
                int result = cmd.ExecuteNonQuery();
                if (result < 1)
    


Ïà¹ØÎĵµ£º

´ò¿ªoracle 10g ÆóÒµ¹ÜÀíÆ÷

 ×°Á˸öOracle 10g£¬È´·¢ÏÖÕÒ²»µ½ÆóÒµ¹ÜÀíÆ÷ÁË¡£Ô­À´10gÓÖÉý¼¶Á˹ÜÀí¹¤¾ß£¬²»ÔÙ²ÉÓÃ8i, 9iµÄÄÇЩJava¹¤¾ßÁË£¬¶øÊÇÓëʱ¾ã½øµØ¸ÄÓÃÁËWeb·½Ê½¡£°´ÕÕÍøÉϵķ½·¨£ºhttp://»úÆ÷µÄIPµØÖ·:5500/em£¬»¹ÊÇûÓÐÁ¬ÉÏ¡£ÄѵÀ¶Ë¿ÚºÅ²»¶ÔÂð£¿
     ²é¿´Oracle 10g°²×°Ä¿Â¼installϵÄreadmeÎļþ£º
ÏÔʾ£º
Êý¾Ý ......

³õʶoracleÖеÄË÷Òý×éÖ¯±í

 Ë÷Òý×éÖ¯±í£¨IOT£©ÓÐÒ»ÖÖÀàBÊ÷µÄ´æ´¢×éÖ¯·½·¨¡£ÆÕͨµÄ¶Ñ×éÖ¯±íÊÇÒÔÒ»ÖÖÎÞÐòµÄ¼¯ºÏ´æ´¢¡£¶øIOTÖеÄÊý¾ÝÊǰ´Ö÷¼üÓÐÐòµÄ´æ´¢ÔÚBÊ÷Ë÷Òý½á¹¹ÖС£ÓëÒ»°ãBÊ÷Ë÷Òý²»Í¬µÄµÄÊÇ£¬ÔÚIOTÖÐÿ¸öÒ¶½áµã¼´ÓÐÿÐеÄÖ÷¼üÁÐÖµ£¬ÓÖÓÐÄÇЩ·ÇÖ÷¼üÁÐÖµ¡£
ÈçÏÂͼËùʾ£¬ÔÚIOTËù¶ÔÓ¦µÄBÊ÷½á¹¹ÖУ¬Ã¿¸öË÷ÒýÏî°üÀ¨<Ö÷¼üÁÐÖµ£¬·ÇÖ÷¼üÁÐÖµ>¶ø ......

oracle½¨Á¢±í¿Õ¼ä

1.oralceɾ³ýÃüÁî
1.1.ɾ³ýÓû§
drop user username cascade;
1.2.ɾ³ý±í¿Õ¼ä
DROP TABLESPACE dataspace INCLUDING CONTENTS AND DATAFILES;
2.´´½¨±í¿Õ¼ä
2.1.½¨Á¢±í¿Õ¼ä
CREATE TABLESPACE dataspace
DATAFILE '/Ŀ¼/dataspace.dbf' SIZE 500M
UNIFORM SIZE 128k; //Ö¸¶¨Çø³ß´çΪ128k,Èç²»Ö¸¶¨£¬Çø³ß´çĬÈÏÎ ......

oracle ÎïÀí¶Á,Âß¼­¶ÁµÄÀí½â

Ò».ÎïÀí¶Á(physical read)
µ±Êý¾Ý¿éµÚÒ»´Î¶ÁÈ¡µ½,¾Í»á»º´æµ½buffer cache ÖÐ,¶øµÚ¶þ´Î¶ÁÈ¡ºÍÐ޸ĸÃÊý¾Ý¿éʱ¾ÍÔÚÄÚ´æbuffer cache ÁË ÒÔÏÂÊÇÀý×Ó:
1.1 µÚÒ»´Î¶ÁÈ¡:
C:"Documents and Settings"Paul Yi>sqlplus "/as sysdba"
SQL*Plus: Release 9.2.0.4.0 - Production on Thu Feb 28 09:32:04 2008
Copyright (c) 19 ......

ORACLE ʱ¼ä×Ö¶ÎÅÅÐòÎÊÌâ

 ORACLE ʱ¼ä×Ö¶ÎÅÅÐòÎÊÌâ
ÔçÉÏÔÚŪEXTÅÅÐòµÄʱºò£¬ÒòΪÊý¾Ý¿âIDÊÇSTRINGµÄ£¬Òò´ËÔÚcommandÀàÀï¶àÁËÒ»¸öinteger idSort×ֶΣ¬
ûÏëµ½£¬¸ù¾ÝÕâ¸öÕûÐ͵Ä×ֶνøÐÐÅÅÐòÒ²²»ÐУ¬ÒòΪEXT·ÖÒ³³öÀ´µÄËäÈ»ÊǸù¾ÝÕâ¸öÕûÐÍ×Ö¶ÎÅÅÐòÁË¡£µ«ÊÇ
¸÷¸öÒ³ÃæÃ»ÓÐÍêÈ«µÄͳһÅÅÐò¡£
Òò´Ë£¬ÔÚDAOÀïдÁËÈçÏÂHQLÓï¾ä£º
select tbl from Tr ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ