| Oracle Call Interface Programmer's Guide Release 2 (9.2) Part Number A96584-01  | 
  | 
OCI Datatype Mapping and Manipulation Functions, 73 of 134
Compares two Oracle numbers.
sword OCINumberCmp ( OCIError *err, CONST OCINumber *number1, CONST OCINumber *number2, sword *result );
The OCI error handle. If there is an error, it is recorded in err and this function returns OCI_ERROR. Obtain diagnostic information by calling OCIErrorGet().
Numbers to compare.
Comparison result:
| Comparison result | Output in result parameter | 
|---|---|
|  
 number1 < number2  | 
 
 negative  | 
|  
 number1 = number2  | 
 
 0  | 
|  
 number1 > number2  | 
 
 positive  | 
This function returns an error if any of the number arguments is null.
  | 
![]() Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved.  | 
  |