Data Type Operators

The Operator data type is any parsed expression that returns a value. An operator is used in the form of a special symbol or function.

The following table shows a list of logical operators that Oxla supports:

Type	Name	Operator	Description	Example
Relational	Equal to	=	This shows that the value of one item is equal to another item’s value.	cust_name = 'Mike'
Relational	Greater than	>	This shows that the value of one item is greater than another item’s value.	stock_value > 10
Relational	Less than	<	This shows that the value of one item is less than another item’s value.	stock_value < 20
Relational	Not equal to	<> or !=	Indicates that the value of one item is not equal to the other item’s value.	subj_score != 'FAILED'
Relational	Greater than or equal to	>=	Indicates that the value of one item is greater than or equal to the other item’s value.	prod_price >= 3000
Relational	Less than or equal to	<=	Indicates that the value of one item is less than or equal to the other item’s value.	prod_price <= 9000
Logical	Not	NOT	It shows a record if the condition(s) is NOT TRUE.	NOT true = false
Logical	Is null	IS NULL	Used to check for empty values (NULL values).	WHERE empsalary IS NULL;