C# װ Microsoft Visual Studio .NET Microsoft .NET Framework 1.0 ߰汾 VB.NET
ݿ
˷ĵʹ multimedia_tab ʹ SQL*Plus ûӵݿ⣨ scott/tigerȻ
DROP TABLE multimedia_tab;
CREATE TABLE multimedia_tab(thekey NUMBER(4) PRIMARY KEY, story CLOB, sound BLOB);
INSERT INTO multimedia_tab values(1,'This is a long story.Once upon a time ...',
'656667686970717273747576777879808182838485');
commit;
Ԥ
ռ䣺.cs.vb ļе‘һ’Ӷռ÷dzֵãɱԺڽűʹã
C#
using System;
using System.Text;
using Oracle.DataAccess.Types;
using Oracle.DataAccess.Client;
Visual Basic .NET
Imports System
Imports System.Text
Imports Oracle.DataAccess.Types
Imports Oracle.DataAccess.Client
' 2
' Oracle
Dim txn As OracleTransaction
Dim cmd As OracleCommand = New OracleCommand("", connection)
Dim reader As OracleDataReader
Dim clob As OracleClob
3. κ LOB ¶Ҫһ Oracle ԣ濪ʼ
C#
// 3
//
txn = connection.BeginTransaction();
Visual Basic .NET
' 3
'
txn = connection.BeginTransaction()
4. ʹ FOR UPDATEڸµȻִ䣺
C#
// 4
// ʹ FOR UPDATE Ӿ
cmd.CommandText = "SELECT story FROM multimedia_tab FOR UPDATE";
reader = cmd.ExecuteReader();
Visual Basic .NET
' 4
' ʹ FOR UPDATE Ӿ
cmd.CommandText = "SELECT story FROM multimedia_tab FOR UPDATE"
reader = cmd.ExecuteReader()
// 6
// ĸе CLOB
string ending = " The end.";
// CLOB ӵǰ OracleCLOB ʵ
clob.Append(ending.ToCharArray(), 0, ending.Length);
// ͷ
txn.Commit();
Console.Write("Updated to new data:");
Visual Basic .NET
' 6
' ĸе CLOB
Dim ending As String = " The end."
' CLOB ӵǰ OracleCLOB ʵ
clob.Append(ending.ToCharArray(), 0, ending.Length)' ͷ
txn.Commit()
Console.Write("Updated to new data:")
7. ݿȡ˵Ȼʾڿ̨ϣ
C#
// 7
// ݿȡĵ
// ʹ FOR UPDATE Ӿ
cmd.CommandText = "SELECT story FROM multimedia_tab FOR UPDATE";
reader = cmd.ExecuteReader();
reader.Read();
clob = reader.GetOracleClob(0);
Console.WriteLine(clob.Value);
Console.WriteLine(" ");
Visual Basic .NET
' 7
' ݿȡĵ
' ʹ FOR UPDATE Ӿ
cmd.CommandText = "SELECT story FROM multimedia_tab FOR UPDATE"
reader = cmd.ExecuteReader()
reader.Read()
clob = reader.GetOracleClob(0)
Console.WriteLine(clob.Value)
Console.WriteLine(" ")
8. CLOB ĵǰʵΪݣ
C#
// 8
// ʹþֵ
// Oracle
txn = connection.BeginTransaction();
// OracleCLOB
// ǰʵ
clob.Erase();
// ַдΪֵ
StringBuilder blr1 = new StringBuilder();
blr1.Append("'This is a long story.Once upon a time ...',");
String oldData = blr1.ToString();
Visual Basic .NET
' 8
' ʹþֵ
' Oracle
txn = connection.BeginTransaction()
' OracleCLOB
' ǰʵ
clob.Erase()
' ַдΪֵ
Dim blr1 As StringBuilder = New StringBuilder()
blr1.Append("'This is a long story.Once upon a time ...',")
Dim oldData As String = blr1.ToString()
书签
