The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.
OracleCommand::ExecuteOracleScalar Method ()
.NET Framework (current version)
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.
Assembly: System.Data.OracleClient (in System.Data.OracleClient.dll)
Return Value
Type: System::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.
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();
.NET Framework
Available since 1.1
Available since 1.1
Show: