Edit

OracleCommand.ExecuteOracleScalar Method

  • Reference

Definition

Namespace:
System.Data.OracleClient
Assembly:
System.Data.OracleClient.dll

Executes the query, and returns the first column of the first row in the result set returned by the query as an Oracle-specific data type. Extra columns or rows are ignored.

public:
 System::Object ^ ExecuteOracleScalar();
public object ExecuteOracleScalar ();
member this.ExecuteOracleScalar : unit -> obj
Public Function ExecuteOracleScalar () As Object

Returns

Object

The first column of the first row in the result set as an Oracle-specific data type, or a null reference if the result is a REF CURSOR.

Remarks

Use the ExecuteOracleScalar method to retrieve a single value (for example, an aggregate value) from a database. This requires less code than using the ExecuteReader method, and then performing the operations necessary to generate the single value from the data returned by an OracleDataReader.

A typical ExecuteOracleScalar query can be formatted as in the following C# example:

command.CommandText = "SELECT COUNT(*) AS NumberOfRegions FROM Region";  
count = command.ExecuteOracleScalar();

Applies to

See also