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

ÔÚÏߵȸßÊÖ£¬150·îÉÏ£¬OracleдclobÎÊÌ⣬°ï¶¥ÓзÖ

http://topic.csdn.net/u/20091015/11/5f41b718-7918-4992-8795-2cccc5e957e8.html?seed=1756713731&r=60435954#r_60435954

µÈ¼¶²»¹»Ö»ÄÜ·¢100·Ö£¬ÉÏÃæÕâ¸öÌù»¹ÓÐ50·Ö¡£

²»Ëµ·Ï»°ÁË£¬Çë¿´´úÂ룬ÎÊÌâ¾ÍÊÇÏÂÃæµÄ×¢ÊÍ´¦
C# code:

string sql = @"select POINT_SET from WELLBORE_LOG where ID='1' For Update";
OracleConnection oraOc = new OracleConnection("Integrated Security=no;User ID=ADMIN;Data Source=MyBASE;Password=ADMIN");
oraOc.Open();
OracleCommand ocmd = new OracleCommand(sql, oraOc);
OracleDataReader oraReader = ocmd.ExecuteReader();
using (oraReader)
{
if (oraReader.HasRows)
{
oraReader.Read();
OracleLob clob = oraReader.GetOracleLob(0);

//ÕâÀïµÃµ½µÄclob.Connection ×ÜÊÇΪnull£¬·Ç³£ÈÃÈËÓôÃÆ£¬ÈçºÎ½â¾ö
if (clob.Connection != null && clob != OracleLob.Null)
{
clob.Write(bytes, 0, bytes.Length);
}
clob.Position = 0;
ocmd.Transaction.Commit();
}
}



²»»á Oracle£¬½¨Òé LZ µ½ Oracle ×¨ÇøÈ¥ÎÊÎÊ¿´£º
http://forum.csdn.net/SList/Oracle_Develop

clobÔ


Ïà¹ØÎÊ´ð£º

oracle sql developer ²éѯÏÔʾÖÐÎÄÂÒÂë

»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£ ......

ÖªµÀÔõô°Ñsasµ¼ÈëoracleµÄ½øÀ´¿´¿´

ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ­ÖªµÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......

ssh oracle Á¬½Ó


Ðֵܠ ͼ¹ÒÁË¡£

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value ......

OracleÊý¾Ý¿âÔ½À´Ô½Âý¸ÃÈçºÎ´¦Àí£¿

Êý¾Ý¿â£ºOracle10g(10.2)
Ó¦ÓãºÒ»¸öC#µÄ³ÌÐòдÊý¾Ý¿â£¬Ò»¸öJSP³ÌÐò¶ÁÊý¾Ý¿â
¸ºÔØ£ºÄ¿Ç°´¦ÓÚ¿ª·¢½×¶Î£¬»ù±¾ÉÏÖ»ÓÐ3-4¸öÓû§·ÃÎÊJSPÍøÕ¾¡£
ÏÖÏó£ºÖØÐÂÆô¶¯ºóµÄÊý¾Ý¿â²éѯ·Ç³£¿ì£¬µ«ÊÇÓÃ×ÅÓÃ×ÅÔ½À´Ô½Âý£¬ËùÓÐJSPÍøÒ ......

Toad for oracleµÄʹÓÃÎÊÌâ

ÎÒÓÃÕâ¸ö¹¤¾ß,
´´½¨ÁËÒ»¸ö±í
Ìí¼ÓÁËÒ»Ìõ¼Ç¼
È»ºó²éѯȴ²éѯ²»µ½;
¶øÇÒÈ¥Êý¾Ý¿âÖвéÕÒÒ²ÕÒ²»µ½Õâ¸ö±í;
ÒÔΪδ´´½¨³É¹¦.
ÖØÐ´´½¨±íÈ´ÌáʾÃû³ÆÒÑ´æÔÚ.
Çë½Ì¸÷λ´óÏÀ.Õâ¸öÊÇÔõô»ØÊ°¡
СµÜ³õ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ