Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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½¨Á¢±í¿Õ¼ä

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 ÏëÇå³þÁËÔÙ×ö£¬Òª½÷É÷Щ¡¡ÐÖµÜ

 ÐÇÆÚÒ» ·¢ÏÖÒ»¸ö±íÓкܶàÖظ´Êý¾Ý Ëæ»úʹÓÃɾ³ýÖظ´Êý¾ÝµÄÓï¾ä¡£
ÐÇÆÚ¶þ ·¢ÏÖ ÕâÓï¾äÅÜÁ˺ܾö¼Ã»ÅÜÍ꣬13¸öСʱÁË£¡Ö»²»¹ýɾ³ý10¸öÔµÄÊý¾Ý¶øÒÑ
ÒÀÈ»¶ÏÁËËü£¬¿ÉËü»Ø¹ö»¨ÁË4¸öСʱ£¬ÉÏÎçÓ°ÏìÁËÊý¾Ý¿âµÄ·þÎñËÙ¶ÈÁË¡£
È»ºóÒ»¸öÔÂÒ»¸öÔ¼ì²éÖظ´Êý¾ÝµÄ·¶Î§£¬×îºó¶¨Î»µ½9Ôµ½10Ô¡£É¾³ýËü£¬ÓÃÄÇÌõÓï¾äºÜÂý£¬Ò»¸öСʱºó ......

110¸öoracle³£Óú¯Êý×ܽá

1. ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii(A) A,ascii(a) a,ascii(0) zero,ascii( ) space from dual;
A A ZERO SPACE
--------- --------- --------- ---------
65 97 48 32
2. CHR
¸ø³öÕûÊý,·µ»Ø¶ÔÓ¦µÄ×Ö·û;
SQL> select chr(54740) zhao,chr(65) chr65 from dual;
ZH C
-- ......

Oracle ADF ¼ò½é

ADFÊÇ£¨Application Development Framework£©µÄ¼ò³Æ£¬ËüµÄÇ°ÉíÊÇBC4J¡£ ¹âÌýÕâ¸öÃû×Ö¾ÍÖªµÀËüÊÇÒ»¸öend-to-endµÄ¿ò¼Ü¡£ºÍSpringÒ»ÑùËüÔÚÆóÒµÓ¦Óüܹ¹µÄÿһ¸ö²ã´Î¶¼ÌṩÁËËüµÄÖ§³Ö¡£ADFµÄ¼Ü¹¹ÈçÏÂͼËùʾ£º
ÔÚÿһ²ãADF¶¼ÓÐËüµÄһЩ×é¼þ¡£ÎÒÕâ´ÎÖ÷ÒªÏë½²½²ADFµÄdata binding£¬ÒòΪËü¸ôÀëÁËÒµÎñÂß¼­²ãºÍweb²ã£¬Ê¹µÃÁ½¸ö²ã´Î ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ