dotConnect for Oracle Documentation
Devart.Data.Oracle Namespace / OracleCommand Class / OracleCommand Constructor / OracleCommand Constructor(String)
The text of the query.
Example

OracleCommand Constructor(String)
Initializes a new instance of the OracleCommand class with the text of the query.
Syntax
'Declaration
 
Public Function New( _
   ByVal commandText As String _
)
 

Parameters

commandText
The text of the query.
Remarks
The following table shows initial property values for an instance of OracleCommand.
Properties Initial value
CommandText commandText
Devart.Common.DbCommandBase.CommandTimeout 30
CommandType System.Data.CommandType.Text
Connection null
Example
The following example creates a OracleCommand and sets some of its properties.
public void CreateOracleCommand()
{
  string mySelectQuery = "SELECT * FROM Test.Dept";
  OracleCommand myCommand = new OracleCommand(mySelectQuery);
  myCommand.FetchSize = 100;
}
Public Sub CreateOracleCommand()
  Dim mySelectQuery As String = "SELECT * FROM Test.Dept"
  Dim myCommand As New OracleCommand(mySelectQuery)
  myCommand.FetchSize = 100
End Sub
See Also