Item Method Operators in QBE
Item Method Operators act on a JSON field, transform it's value and then compare it to the comparison value.
The item method operators are analogous to the SQL operators or
functions. Oracle AI Database for GraphQL supports the following item method QBE
operators:
GraphQL QBE Item Method Operator | Equivalent SQL Operator |
---|---|
_abs |
To get the absolute value. This operator is not used since QBE in GraphQL does not support negative numbers. |
_boolean |
To typecast to boolean .
Equivalent of TO_BOOLEAN in SQL.
|
_number |
To typecast to a number .
Equivalent of TO_NUMBER in SQL.
|
_double |
To typecast to binary_double .
Equivalent of TO_BINARY_DOUBLE in SQL.
|
_string |
To typecast to char . Equivalent
of TO_CHAR in SQL.
|
_date |
To type cast to date . Equivalent
of TO_DATE in SQL.
|
_timestamp |
To type cast to timestamp .
Equivalent of TO_TIMESTAMP in SQL.
|
_ceiling |
To get the ceil value of a
number . Equivalent of CEIL
in SQL.
|
_floor |
To get the floor value of a
number . Equivalent of
FLOOR in SQL.
|
_lower |
To convert the string into
lower case. Equivalent of LOWER in
SQL.
|
_upper |
To convert the string into
upper case. Equivalent of UPPER in
SQL.
|
_length |
To get the length of the value.
Equivalent of LENGTH in SQL.
|
_size |
To get the size of data type.
Equivalent of VSIZE in SQL.
|