OracleDbType Property (OracleLoaderColumn)
On this page
Gets or sets the
OracleDbType of the column.
Syntax
Property Value
A
OracleDbType value of the column. The default value is
OracleDbType.VarChar.
Example
|
|---|
public void GetDataColumns(OracleConnection oracleConnection)
{
oracleConnection.Open();
OracleLoader loader = new OracleLoader();
loader.Connection = oracleConnection;
loader.TableName = "load_table";
OracleLoaderColumn myColumn;
try
{
loader.CreateColumns();
for (int i = 0; i < loader.Columns.Count; i++)
{
myColumn = loader.Columns[i];
Console.WriteLine(myColumn.Name);
Console.WriteLine(myColumn.OracleDbType.ToString());
Console.WriteLine(myColumn.Size);
Console.WriteLine(myColumn.Scale);
Console.WriteLine(myColumn.Precision);
Console.WriteLine();
}
}
finally
{
oracleConnection.Close();
}
} |
|
|---|
Public Sub GetDataColumns(ByVal oracleConnection As OracleConnection)
oracleConnection.Open()
Dim loader As OracleLoader
loader = New OracleLoader
loader.Connection = oracleConnection
loader.TableName = "load_table"
Dim myColumn As OracleLoaderColumn
Try
loader.CreateColumns()
Dim i As Integer
For i = 0 To loader.Columns.Count - 1
myColumn = loader.Columns(i)
Console.WriteLine(myColumn.Name)
Console.WriteLine(myColumn.OracleDbType.ToString())
Console.WriteLine(myColumn.Size)
Console.WriteLine(myColumn.Scale)
Console.WriteLine(myColumn.Precision)
Console.WriteLine()
Next i
Finally
oracleConnection.Close()
End Try
End Sub |
See Also