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)
 
Ïà¹ØÎĵµ£º
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Êý¾Ý¿â֪ʶ¡£ÏÂÎÄÊǶÔOracleÊý¾Ý¿âÏà¹Ø¸ÅÄîµÄһЩ±Ê¼Ç¡£
³õѧOracle£¬Àí½âOracleʵÀý¡¢OracleÊý¾Ý¿âºÍOracle·þÎñÆ÷µÈÃû´ÊÊõÓïÊǺÜÖØÒªµÄ¡£
ÊõÓï½âÊÍ:
OracleʵÀý/OracleÊý¾Ý¿â
Ò»°ãOracleÊý¾Ý¿â(Oracle Database)¿ÉÒÔ·ÖΪÁ½²¿ ......
oracleµÄnvlº¯ÊýµÄÓ÷¨ ͨ¹ý²éѯ»ñµÃij¸ö×ֶεĺϼÆÖµ£¬Èç¹ûÕâ¸öֵλnull½«¸ø³öÒ»¸öÔ¤ÉèµÄĬÈÏÖµ
select nvl(sum(t.dwxhl),1) from tb_jhde t where zydm=-1ÕâÀï¹ØÐĵÄnvlµÄÓ÷¨£¬nvl£¨arg,value£©´ú±íÈç¹ûÇ°ÃæµÄargµÄֵΪnullÄÇô·µ»ØµÄֵΪºóÃæµÄvalue
Èç: NVL(a,b)¾ÍÊÇÅжÏaÊÇ·ñÊÇNULL,Èç¹û²»ÊÇ·µ»ØaµÄÖµ£¬Èç¹ ......
Q1.ÔõÑù´´½¨±í£¿
Q2.ÔõÑùɾ³ý±í£¿
Q3.ÔõÑù´´½¨ÊÓͼ£¿
Q4.ÔõÑùɾ³ýÊÓͼ£¿
Q5.ÔõÑù¸ø±íÌí¼Ó×ֶΣ¿
Q6.ÔõÑùɾ³ý±íÖÐij¸ö×ֶΣ¿
Q7.ÔõÑù¸øij¸ö×Ö¶ÎÌí¼ÓÔ¼Êø£¿
Q8.ÔõÑùÈ¥³ýij¸ö×Ö¶ÎÉϵÄÔ¼Êø£¿
Q9.ÔõÑù¸ø±í¼ÓÉÏÖ÷¼ü£¿
Q10.ÔõÑùɾ³ý±íµÄÖ÷¼ü£¿
Q11.ÔõÑù¸ø±íÌí¼ÓÒ»¸öÍâ¼ü£¿
......
±¾»úµçÄÔÉÏÓа²×°ORACLE10GµÄ¿Í»§¶Ë£¬ºóÀ´ÓÉÓÚÐèÒªÍæÁËÒ»ÏÂODAC£¬ºóÀ´ÓÖжÔصôÁË¡£½á¹û£¬Ê¹ÓÃC#½øÐÐÁ¬½ÓµÄʱºò±¨£º
δÔÚ±¾µØ¼ÆËã»ú×¢²á“OraOLEDB.Oracle.1”Ìṩ³ÌÐò
È»ºó£¬Ð½¨Ò»¸öUDL½øÐвâÊÔ£¬·¢ÏÖOracle Provider & ......