Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÖеÄË÷Òý×éÖ¯±í

 Ë÷Òý×éÖ¯±í£¨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µÄÓ²½âÎöºÍÈí½âÎö

˵µ½Èí½âÎö£¨soft prase£©ºÍÓ²½âÎö£¨hard prase£©£¬¾Í²»Äܲ»ËµÒ»ÏÂOracle¶ÔsqlµÄ´¦Àí¹ý³Ì¡£µ±Äã·¢³öÒ»ÌõsqlÓï¾ä½»¸¶Oracle£¬ÔÚÖ´ÐкͻñÈ¡½á¹ûǰ£¬Oracle¶Ô´Ësql½«½øÐм¸¸ö²½ÖèµÄ´¦Àí¹ý³Ì£º
 
1¡¢Óï·¨¼ì²é£¨syntax check£©
¼ì²é´ËsqlµÄƴдÊÇ·ñÓï·¨¡£
2¡¢ÓïÒå¼ì²é£¨semantic check£©
ÖîÈç¼ì²ésqlÓï¾äÖеķÃÎÊ¶Ô ......

OracleδÌṩÏàÓ¦Çý¶¯

  ±¾»úµçÄÔÉÏÓа²×°ORACLE10GµÄ¿Í»§¶Ë£¬ºóÀ´ÓÉÓÚÐèÒªÍæÁËÒ»ÏÂODAC£¬ºóÀ´ÓÖÐ¶ÔØµôÁË¡£½á¹û£¬Ê¹ÓÃC#½øÐÐÁ¬½ÓµÄʱºò±¨£º
        δÔÚ±¾µØ¼ÆËã»ú×¢²á“OraOLEDB.Oracle.1”Ìṩ³ÌÐò
  È»ºó£¬Ð½¨Ò»¸öUDL½øÐвâÊÔ£¬·¢ÏÖOracle   Provider & ......

ORACLE³£ÓÃת»»º¯Êý¡¢ÊýÖµº¯Êý¡¢×Ö·û´®º¯Êý½éÉÜ

±¾ÎÄÀ´×Ô£ºWWW.NC21.CN  ÐÂÊÀ¼ÍÆ½Ì¨Íø  
±¾Îĸü¶à½«»á½éÉÜÈý˼ÔÚÈÕ³£Öо­³£»áÓõ½µÄ£¬»òÕßËäÈ»ºÜÉÙÓõ½£¬µ«ÊǸоõͦÓÐÒâ˼µÄһЩº¯Êý¡£·Ö¶þÀà½éÉÜ£¬·Ö±ðÊÇ£º
¡¡¡¡ÖøÃûº¯Êýƪ¡¡£­¾­³£Óõ½µÄº¯Êý
¡¡¡¡·ÇÖøÃûº¯Êýƪ£­¼´ËäÈ»ºÜÉÙÓõ½£¬µ«Ä³Ð©Çé¿öÏÂÈ´ºÜʵÓÃ
¡¡¡¡×¢£ºN±íʾÊý×ÖÐÍ£¬C±íʾ×Ö·ûÐÍ£¬D±íʾ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ