//CLOB数据的插入:
using (OracleConnection connection = new OracleConnection(connectStr))
{
OracleCommand cmd = connection.CreateCommand())
//创建命令
cmd.CommandText = "INSERT INTO MyTable (ClobField) VALUES (:context))"
//创建命令中对应的参数
OracleParameter myParameter = new OracleParameter(":context", OracleType.Clob);
//设置参数的值
myParameter.Value = strOfClob;
//绑定参数至命令
cmd.Parameters.Add(myParameter);
//执行命令
cmd.ExecuteNonQuery();
}
//CLOB数据的获取:
//方式一:速度慢
using (OracleConnection connection = new OracleConnection(connectStr))
{
string querySql="Select ClobField From MyTable";
OracleDataAdapter adapter = new OracleDataAdapter(querySql, oraconnection);
DataSet ds = new DataSet(); //填充数据集
adapter.Fill(ds);
string clobContext = null;
foreach (DataRow dataRow in ds.Tables[0].Rows)
{
//获取内容
clobContext = Convert.ToString(dataRow[&
ORACLE数据库中CLOB数据的插入和快速读取
最新推荐文章于 2023-03-28 16:25:39 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)