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

¶ÁÈ¡oracle blob×Ö·û´®

OleDbConnectioncon=newOleDbConnection(cnnstr);
try
{
con.Open();
}
catch
{}
OleDbCommandcmd=newOleDbCommand(strSQL,con);
System.Data.OleDb.OleDbDataReaderdr=cmd.ExecuteReader();
while(dr.Read())
 
{
stringdd=dr["gggg"].ToString();
byte[]ooo=(byte[])dr["hhhh"];
stringstr;
str=System.Text.Encoding.Unicode.GetString(ooo);
this.textBox1.Text=str;
 
}
}
 
 
 //ÏòÊý¾Ý¿âÖÐдÈë
        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;
&nbs


Ïà¹ØÎĵµ£º

OracleÊý¾Ýµ¼Èëµ¼³öimp/exp

¹¦ÄÜ£ºOracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓëoracleÊý¾Ý»¹Ô­Ó뱸·Ý¡£´ó¶àÇé¿ö¶¼¿ÉÒÔÓÃOracleÊý¾Ýµ¼Èëµ¼³öÍê³ÉÊý¾ÝµÄ±¸·ÝºÍ»¹Ô­£¨²»»áÔì³ÉÊý¾ÝµÄ¶ªÊ§£©¡£
¡¡¡¡OracleÓиöºÃ´¦£¬ËäÈ»ÄãµÄµçÄÔ²»ÊÇ·þÎñÆ÷£¬µ«ÊÇÄã×°ÁËoracle¿Í»§¶Ë£¬²¢½¨Á¢ÁËÁ¬½Ó £¨Í¨¹ýnet8 assistantÖб¾µØ——>·þÎñÃüÃû Ìí¼ÓÕýÈ·µÄ·þÎñÃüÃû
¡¡¡¡Æ ......

ORACLEÖÐLikeÓëInstrÐÔÄÜ´ó±ÈÆ´

t±íÖн«½üÓÐ1100ÍòÊý¾Ý£¬ºÜ¶àʱºò£¬ÎÒÃÇÒª½øÐÐ×Ö·û´®Æ¥Å䣬ÔÚSQLÓï¾äÖУ¬ÎÒÃÇͨ³£Ê¹ÓÃlikeÀ´´ïµ½ÎÒÃÇËÑË÷µÄÄ¿±ê¡£µ«¾­¹ýʵ¼Ê²âÊÔ·¢ÏÖ£¬likeµÄЧÂÊÓëinstrº¯Êý²î±ðÏ൱´ó¡£ÏÂÃæÊÇһЩ²âÊÔ½á¹û£º
SQL> set timing on
SQL> select count(*) from t where instr(title,’ÊÖ²á’)>0;
COUNT(*)
—&md ......

RedHat Linux°²×°Oracle10g(ͼÎÄÏê½â ½Ì³Ì)

RedHat Linux°²×°Oracle10g(ͼÎÄÏê½â ½Ì³Ì)
http://winie.javaeye.com/blog/405120
¹Ø¼ü×Ö: redhat linux°²×°oracle10g(ͼÎÄÏê½â ½Ì³Ì)

Áí£¬±¾ÈËÓÐWordµç×ÓÎĵµ¸ñʽ£¬ÈçÐèÒª£¬ÇëÁªÏµ±¾ÈË£ºasima127@gmail.com
  
1     
°²×°RedHat Enterprise Linux 3 ......

Two papers on Oracle 11g Security

Hey all,
Since there seems to be a fair bit of disinformation, and utter nonsense,
floating around since my talk at the Black Hat Federal security conference
the other day, I have decided to publish the following papers.
http://www.databasesecurity.com/HackingAurora.pdf
http://www.databasesec ......

ORACLEÓαê

ORACLEÓαê
Óα꣺ÈÝÆ÷£¬´æ·Åµ±Ç°SQLÓï¾äÓ°ÏìµÄ¼Ç¼
       ËùÓÐDMLÓï¾ä¶¼»áÓõ½Óαê
      
       ÖðÐд¦ÀíÓ°ÏìµÄÐÐÊý
 
Óαê
       ¾²Ì¬Óα꣺ÓαêÓëSQLÓï¾äÔÚÔËÐÐǰ¹ØÁª
&nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ