Sql
Operator
Type
AND
BETWEEN
BITAND
BITNOT
BITOR
CONCAT
DIFF
DIV
EQ
GEQ
GT
ILIKE
IN
IS
ISNOTNULL
ISNULL
LEQ
LIKE
LT
MINUS
NOT
NOTILIKE
NOTIN
NOTLIKE
NOT_
REGEXP
NOT_
REGEXP_
CI
OR
PLUS
REGEXP
REGEXP_
CI
REM
SIMILAR
STAR
GJS API Reference
Gda-6.0
Gda
SqlOperatorType
Enumeration SqlOperatorType
Index
Enumeration Members
AND
BETWEEN
BITAND
BITNOT
BITOR
CONCAT
DIFF
DIV
EQ
GEQ
GT
ILIKE
IN
IS
ISNOTNULL
ISNULL
LEQ
LIKE
LT
MINUS
NOT
NOTILIKE
NOTIN
NOTLIKE
NOT_
REGEXP
NOT_
REGEXP_
CI
OR
PLUS
REGEXP
REGEXP_
CI
REM
SIMILAR
STAR
Enumeration Members
AND
AND
:
number
BETWEEN
BETWEEN
:
number
BITAND
BITAND
:
number
BITNOT
BITNOT
:
number
BITOR
BITOR
:
number
CONCAT
CONCAT
:
number
DIFF
DIFF
:
number
DIV
DIV
:
number
EQ
EQ
:
number
GEQ
GEQ
:
number
GT
GT
:
number
ILIKE
ILIKE
:
number
IN
IN
:
number
IS
IS
:
number
ISNOTNULL
ISNOTNULL
:
number
ISNULL
ISNULL
:
number
LEQ
LEQ
:
number
LIKE
LIKE
:
number
LT
LT
:
number
MINUS
MINUS
:
number
NOT
NOT
:
number
NOTILIKE
NOTILIKE
:
number
NOTIN
NOTIN
:
number
NOTLIKE
NOTLIKE
:
number
NOT_
REGEXP
NOT_
REGEXP
:
number
NOT_
REGEXP_
CI
NOT_
REGEXP_
CI
:
number
OR
OR
:
number
PLUS
PLUS
:
number
REGEXP
REGEXP
:
number
REGEXP_
CI
REGEXP_
CI
:
number
REM
REM
:
number
SIMILAR
SIMILAR
:
number
STAR
STAR
:
number
Sql
Operator
Type
AND
BETWEEN
BITAND
BITNOT
BITOR
CONCAT
DIFF
DIV
EQ
GEQ
GT
ILIKE
IN
IS
ISNOTNULL
ISNULL
LEQ
LIKE
LT
MINUS
NOT
NOTILIKE
NOTIN
NOTLIKE
NOT_
REGEXP
NOT_
REGEXP_
CI
OR
PLUS
REGEXP
REGEXP_
CI
REM
SIMILAR
STAR
base64:eyJwYWdlTmF2aWdhdGlvbiI6W3siY2xhc3NOYW1lcyI6InRzZC1raW5kLWVudW0tbWVtYmVyIHRzZC1wYXJlbnQta2luZC1lbnVtIiwiaHJlZiI6IkdkYV82XzAuR2RhLlNxbE9wZXJhdG9yVHlwZS5odG1sI0FORCIsIm5hbWUiOiJBTkQiLCJjaGlsZHJlbiI6W10sImlzRXh0ZXJuIjpmYWxzZSwiaXNJbnRlcm4iOnRydWV9LHsiY2xhc3NOYW1lcyI6InRzZC1raW5kLWVudW0tbWVtYmVyIHRzZC1wYXJlbnQta2luZC1lbnVtIiwiaHJlZiI6IkdkYV82XzAuR2RhLlNxbE9wZXJhdG9yVHlwZS5odG1sI0JFVFdFRU4iLCJuYW1lIjoiQkVUV0VFTiIsImNoaWxkcmVuIjpbXSwiaXNFeHRlcm4iOmZhbHNlLCJpc0ludGVybiI6dHJ1ZX0seyJjbGFzc05hbWVzIjoidHNkLWtpbmQtZW51bS1tZW1iZXIgdHNkLXBhcmVudC1raW5kLWVudW0iLCJocmVmIjoiR2RhXzZfMC5HZGEuU3FsT3BlcmF0b3JUeXBlLmh0bWwjQklUQU5EIiwibmFtZSI6IkJJVEFORCIsImNoaWxkcmVuIjpbXSwiaXNFeHRlcm4iOmZhbHNlLCJpc0ludGVybiI6dHJ1ZX0seyJjbGFzc05hbWVzIjoidHNkLWtpbmQtZW51bS1tZW1iZXIgdHNkLXBhcmVudC1raW5kLWVudW0iLCJocmVmIjoiR2RhXzZfMC5HZGEuU3FsT3BlcmF0b3JUeXBlLmh0bWwjQklUTk9UIiwibmFtZSI6IkJJVE5PVCIsImNoaWxkcmVuIjpbXSwiaXNFeHRlcm4iOmZhbHNlLCJpc0ludGVybiI6dHJ1ZX0seyJjbGFzc05hbWVzIjoidHNkLWtpbmQtZW51bS1tZW1iZXIgdHNkLXBhcmVudC1raW5kLWVudW0iLCJocmVmIjoiR2RhXzZfMC5HZGEuU3FsT3BlcmF0b3JUeXBlLmh0bWwjQklUT1IiLCJuYW1lIjoiQklUT1IiLCJjaGlsZHJlbiI6W10sImlzRXh0ZXJuIjpmYWxzZSwiaXNJbnRlcm4iOnRydWV9LHsiY2xhc3NOYW1lcyI6InRzZC1raW5kLWVudW0tbWVtYmVyIHRzZC1wYXJlbnQta2luZC1lbnVtIiwiaHJlZiI6IkdkYV82XzAuR2RhLlNxbE9wZXJhdG9yVHlwZS5odG1sI0NPTkNBVCIsIm5hbWUiOiJDT05DQVQiLCJjaGlsZHJlbiI6W10sImlzRXh0ZXJuIjpmYWxzZSwiaXNJbnRlcm4iOnRydWV9LHsiY2xhc3NOYW1lcyI6InRzZC1raW5kLWVudW0tbWVtYmVyIHRzZC1wYXJlbnQta2luZC1lbnVtIiwiaHJlZiI6IkdkYV82XzAuR2RhLlNxbE9wZXJhdG9yVHlwZS5odG1sI0RJRkYiLCJuYW1lIjoiRElGRiIsImNoaWxkcmVuIjpbXSwiaXNFeHRlcm4iOmZhbHNlLCJpc0ludGVybiI6dHJ1ZX0seyJjbGFzc05hbWVzIjoidHNkLWtpbmQtZW51bS1tZW1iZXIgdHNkLXBhcmVudC1raW5kLWVudW0iLCJocmVmIjoiR2RhXzZfMC5HZGEuU3FsT3BlcmF0b3JUeXBlLmh0bWwjRElWIiwibmFtZSI6IkRJViIsImNoaWxkcmVuIjpbXSwiaXNFeHRlcm4iOmZhbHNlLCJpc0ludGVybiI6dHJ1ZX0seyJjbGFzc05hbWVzIjoidHNkLWtpbmQtZW51bS1tZW1iZXIgdHNkLXBhcmVudC1raW5kLWVudW0iLCJocmVmIjoiR2RhXzZfMC5HZGEuU3FsT3BlcmF0b3JUeXBlLmh0bWwjRVEiLCJuYW1lIjoiRVEiLCJjaGlsZHJlbiI6W10sImlzRXh0ZXJuIjpmYWxzZSwiaXNJbnRlcm4iOnRydWV9LHsiY2xhc3NOYW1lcyI6InRzZC1raW5kLWVudW0tbWVtYmVyIHRzZC1wYXJlbnQta2luZC1lbnVtIiwiaHJlZiI6IkdkYV82XzAuR2RhLlNxbE9wZXJhdG9yVHlwZS5odG1sI0dFUSIsIm5hbWUiOiJHRVEiLCJjaGlsZHJlbiI6W10sImlzRXh0ZXJuIjpmYWxzZSwiaXNJbnRlcm4iOnRydWV9LHsiY2xhc3NOYW1lcyI6InRzZC1raW5kLWVudW0tbWVtYmVyIHRzZC1wYXJlbnQta2luZC1lbnVtIiwiaHJlZiI6IkdkYV82XzAuR2RhLlNxbE9wZXJhdG9yVHlwZS5odG1sI0dUIiwibmFtZSI6IkdUIiwiY2hpbGRyZW4iOltdLCJpc0V4dGVybiI6ZmFsc2UsImlzSW50ZXJuIjp0cnVlfSx7ImNsYXNzTmFtZXMiOiJ0c2Qta2luZC1lbnVtLW1lbWJlciB0c2QtcGFyZW50LWtpbmQtZW51bSIsImhyZWYiOiJHZGFfNl8wLkdkYS5TcWxPcGVyYXRvclR5cGUuaHRtbCNJTElLRSIsIm5hbWUiOiJJTElLRSIsImNoaWxkcmVuIjpbXSwiaXNFeHRlcm4iOmZhbHNlLCJpc0ludGVybiI6dHJ1ZX0seyJjbGFzc05hbWVzIjoidHNkLWtpbmQtZW51bS1tZW1iZXIgdHNkLXBhcmVudC1raW5kLWVudW0iLCJocmVmIjoiR2RhXzZfMC5HZGEuU3FsT3BlcmF0b3JUeXBlLmh0bWwjSU4iLCJuYW1lIjoiSU4iLCJjaGlsZHJlbiI6W10sImlzRXh0ZXJuIjpmYWxzZSwiaXNJbnRlcm4iOnRydWV9LHsiY2xhc3NOYW1lcyI6InRzZC1raW5kLWVudW0tbWVtYmVyIHRzZC1wYXJlbnQta2luZC1lbnVtIiwiaHJlZiI6IkdkYV82XzAuR2RhLlNxbE9wZXJhdG9yVHlwZS5odG1sI0lTIiwibmFtZSI6IklTIiwiY2hpbGRyZW4iOltdLCJpc0V4dGVybiI6ZmFsc2UsImlzSW50ZXJuIjp0cnVlfSx7ImNsYXNzTmFtZXMiOiJ0c2Qta2luZC1lbnVtLW1lbWJlciB0c2QtcGFyZW50LWtpbmQtZW51bSIsImhyZWYiOiJHZGFfNl8wLkdkYS5TcWxPcGVyYXRvclR5cGUuaHRtbCNJU05PVE5VTEwiLCJuYW1lIjoiSVNOT1ROVUxMIiwiY2hpbGRyZW4iOltdLCJpc0V4dGVybiI6ZmFsc2UsImlzSW50ZXJuIjp0cnVlfSx7ImNsYXNzTmFtZXMiOiJ0c2Qta2luZC1lbnVtLW1lbWJlciB0c2QtcGFyZW50LWtpbmQtZW51bSIsImhyZWYiOiJHZGFfNl8wLkdkYS5TcWxPcGVyYXRvclR5cGUuaHRtbCNJU05VTEwiLCJuYW1lIjoiSVNOVUxMIiwiY2hpbGRyZW4iOltdLCJpc0V4dGVybiI6ZmFsc2UsImlzSW50ZXJuIjp0cnVlfSx7ImNsYXNzTmFtZXMiOiJ0c2Qta2luZC1lbnVtLW1lbWJlciB0c2QtcGFyZW50LWtpbmQtZW51bSIsImhyZWYiOiJHZGFfNl8wLkdkYS5TcWxPcGVyYXRvclR5cGUuaHRtbCNMRVEiLCJuYW1lIjoiTEVRIiwiY2hpbGRyZW4iOltdLCJpc0V4dGVybiI6ZmFsc2UsImlzSW50ZXJuIjp0cnVlfSx7ImNsYXNzTmFtZXMiOiJ0c2Qta2luZC1lbnVtLW1lbWJlciB0c2QtcGFyZW50LWtpbmQtZW51bSIsImhyZWYiOiJHZGFfNl8wLkdkYS5TcWxPcGVyYXRvclR5cGUuaHRtbCNMSUtFIiwibmFtZSI6IkxJS0UiLCJjaGlsZHJlbiI6W10sImlzRXh0ZXJuIjpmYWxzZSwiaXNJbnRlcm4iOnRydWV9LHsiY2xhc3NOYW1lcyI6InRzZC1raW5kLWVudW0tbWVtYmVyIHRzZC1wYXJlbnQta2luZC1lbnVtIiwiaHJlZiI6IkdkYV82XzAuR2RhLlNxbE9wZXJhdG9yVHlwZS5odG1sI0xUIiwibmFtZSI6IkxUIiwiY2hpbGRyZW4iOltdLCJpc0V4dGVybiI6ZmFsc2UsImlzSW50ZXJuIjp0cnVlfSx7ImNsYXNzTmFtZXMiOiJ0c2Qta2luZC1lbnVtLW1lbWJlciB0c2QtcGFyZW50LWtpbmQtZW51bSIsImhyZWYiOiJHZGFfNl8wLkdkYS5TcWxPcGVyYXRvclR5cGUuaHRtbCNNSU5VUyIsIm5hbWUiOiJNSU5VUyIsImNoaWxkcmVuIjpbXSwiaXNFeHRlcm4iOmZhbHNlLCJpc0ludGVybiI6dHJ1ZX0seyJjbGFzc05hbWVzIjoidHNkLWtpbmQtZW51bS1tZW1iZXIgdHNkLXBhcmVudC1raW5kLWVudW0iLCJocmVmIjoiR2RhXzZfMC5HZGEuU3FsT3BlcmF0b3JUeXBlLmh0bWwjTk9UIiwibmFtZSI6Ik5PVCIsImNoaWxkcmVuIjpbXSwiaXNFeHRlcm4iOmZhbHNlLCJpc0ludGVybiI6dHJ1ZX0seyJjbGFzc05hbWVzIjoidHNkLWtpbmQtZW51bS1tZW1iZXIgdHNkLXBhcmVudC1raW5kLWVudW0iLCJocmVmIjoiR2RhXzZfMC5HZGEuU3FsT3BlcmF0b3JUeXBlLmh0bWwjTk9USUxJS0UiLCJuYW1lIjoiTk9USUxJS0UiLCJjaGlsZHJlbiI6W10sImlzRXh0ZXJuIjpmYWxzZSwiaXNJbnRlcm4iOnRydWV9LHsiY2xhc3NOYW1lcyI6InRzZC1raW5kLWVudW0tbWVtYmVyIHRzZC1wYXJlbnQta2luZC1lbnVtIiwiaHJlZiI6IkdkYV82XzAuR2RhLlNxbE9wZXJhdG9yVHlwZS5odG1sI05PVElOIiwibmFtZSI6Ik5PVElOIiwiY2hpbGRyZW4iOltdLCJpc0V4dGVybiI6ZmFsc2UsImlzSW50ZXJuIjp0cnVlfSx7ImNsYXNzTmFtZXMiOiJ0c2Qta2luZC1lbnVtLW1lbWJlciB0c2QtcGFyZW50LWtpbmQtZW51bSIsImhyZWYiOiJHZGFfNl8wLkdkYS5TcWxPcGVyYXRvclR5cGUuaHRtbCNOT1RMSUtFIiwibmFtZSI6Ik5PVExJS0UiLCJjaGlsZHJlbiI6W10sImlzRXh0ZXJuIjpmYWxzZSwiaXNJbnRlcm4iOnRydWV9LHsiY2xhc3NOYW1lcyI6InRzZC1raW5kLWVudW0tbWVtYmVyIHRzZC1wYXJlbnQta2luZC1lbnVtIiwiaHJlZiI6IkdkYV82XzAuR2RhLlNxbE9wZXJhdG9yVHlwZS5odG1sI05PVF9SRUdFWFAiLCJuYW1lIjoiTk9UX1JFR0VYUCIsImNoaWxkcmVuIjpbXSwiaXNFeHRlcm4iOmZhbHNlLCJpc0ludGVybiI6dHJ1ZX0seyJjbGFzc05hbWVzIjoidHNkLWtpbmQtZW51bS1tZW1iZXIgdHNkLXBhcmVudC1raW5kLWVudW0iLCJocmVmIjoiR2RhXzZfMC5HZGEuU3FsT3BlcmF0b3JUeXBlLmh0bWwjTk9UX1JFR0VYUF9DSSIsIm5hbWUiOiJOT1RfUkVHRVhQX0NJIiwiY2hpbGRyZW4iOltdLCJpc0V4dGVybiI6ZmFsc2UsImlzSW50ZXJuIjp0cnVlfSx7ImNsYXNzTmFtZXMiOiJ0c2Qta2luZC1lbnVtLW1lbWJlciB0c2QtcGFyZW50LWtpbmQtZW51bSIsImhyZWYiOiJHZGFfNl8wLkdkYS5TcWxPcGVyYXRvclR5cGUuaHRtbCNPUiIsIm5hbWUiOiJPUiIsImNoaWxkcmVuIjpbXSwiaXNFeHRlcm4iOmZhbHNlLCJpc0ludGVybiI6dHJ1ZX0seyJjbGFzc05hbWVzIjoidHNkLWtpbmQtZW51bS1tZW1iZXIgdHNkLXBhcmVudC1raW5kLWVudW0iLCJocmVmIjoiR2RhXzZfMC5HZGEuU3FsT3BlcmF0b3JUeXBlLmh0bWwjUExVUyIsIm5hbWUiOiJQTFVTIiwiY2hpbGRyZW4iOltdLCJpc0V4dGVybiI6ZmFsc2UsImlzSW50ZXJuIjp0cnVlfSx7ImNsYXNzTmFtZXMiOiJ0c2Qta2luZC1lbnVtLW1lbWJlciB0c2QtcGFyZW50LWtpbmQtZW51bSIsImhyZWYiOiJHZGFfNl8wLkdkYS5TcWxPcGVyYXRvclR5cGUuaHRtbCNSRUdFWFAiLCJuYW1lIjoiUkVHRVhQIiwiY2hpbGRyZW4iOltdLCJpc0V4dGVybiI6ZmFsc2UsImlzSW50ZXJuIjp0cnVlfSx7ImNsYXNzTmFtZXMiOiJ0c2Qta2luZC1lbnVtLW1lbWJlciB0c2QtcGFyZW50LWtpbmQtZW51bSIsImhyZWYiOiJHZGFfNl8wLkdkYS5TcWxPcGVyYXRvclR5cGUuaHRtbCNSRUdFWFBfQ0kiLCJuYW1lIjoiUkVHRVhQX0NJIiwiY2hpbGRyZW4iOltdLCJpc0V4dGVybiI6ZmFsc2UsImlzSW50ZXJuIjp0cnVlfSx7ImNsYXNzTmFtZXMiOiJ0c2Qta2luZC1lbnVtLW1lbWJlciB0c2QtcGFyZW50LWtpbmQtZW51bSIsImhyZWYiOiJHZGFfNl8wLkdkYS5TcWxPcGVyYXRvclR5cGUuaHRtbCNSRU0iLCJuYW1lIjoiUkVNIiwiY2hpbGRyZW4iOltdLCJpc0V4dGVybiI6ZmFsc2UsImlzSW50ZXJuIjp0cnVlfSx7ImNsYXNzTmFtZXMiOiJ0c2Qta2luZC1lbnVtLW1lbWJlciB0c2QtcGFyZW50LWtpbmQtZW51bSIsImhyZWYiOiJHZGFfNl8wLkdkYS5TcWxPcGVyYXRvclR5cGUuaHRtbCNTSU1JTEFSIiwibmFtZSI6IlNJTUlMQVIiLCJjaGlsZHJlbiI6W10sImlzRXh0ZXJuIjpmYWxzZSwiaXNJbnRlcm4iOnRydWV9LHsiY2xhc3NOYW1lcyI6InRzZC1raW5kLWVudW0tbWVtYmVyIHRzZC1wYXJlbnQta2luZC1lbnVtIiwiaHJlZiI6IkdkYV82XzAuR2RhLlNxbE9wZXJhdG9yVHlwZS5odG1sI1NUQVIiLCJuYW1lIjoiU1RBUiIsImNoaWxkcmVuIjpbXSwiaXNFeHRlcm4iOmZhbHNlLCJpc0ludGVybiI6dHJ1ZX1dLCJjbGFzc05hbWVzIjoiY3VycmVudCB0c2Qta2luZC1lbnVtIHRzZC1wYXJlbnQta2luZC1uYW1lc3BhY2UiLCJocmVmIjoiR2RhXzZfMC5HZGEuU3FsT3BlcmF0b3JUeXBlLmh0bWwiLCJuYW1lIjoiU3FsT3BlcmF0b3JUeXBlIn0=