Operators and Functions

• Logical Operators
• Comparison Operators
• Arithmetic Operators
  • Arithmetic Operations and Type Casting of Numeric Data Types
  • Arithmetic Operations and Type Casting of DATE/TIME Data Types
• Set Arithmetic Operators
  • SET, MULTISET, LIST
• Statement Set Operators
  • UNION, DIFFERENCE, INTERSECTION
• Containment Operators
  • SETEQ
  • SETNEQ
  • SUPERSET
  • SUPERSETEQ
  • SUBSET
  • SUBSETEQ
• BIT Functions and Operators
  • Bitwise Operator
  • BIT_AND
  • BIT_OR
  • BIT_XOR
  • BIT_COUNT
• String Functions and Operators
  • Concatenation Operator
  • ASCII
  • BIN
  • BIT_LENGTH
  • CHAR_LENGTH, CHARACTER_LENGTH, LENGTHB, LENGTH
  • CHR
  • CONCAT
  • CONCAT_WS
  • ELT
  • FIELD
  • FIND_IN_SET
  • FROM_BASE64
  • INSERT
  • INSTR
  • LCASE, LOWER
  • LEFT
  • LOCATE
  • LPAD
  • LTRIM
  • MID
  • OCTET_LENGTH
  • POSITION
  • REPEAT
  • REPLACE
  • REVERSE
  • RIGHT
  • RPAD
  • RTRIM
  • SPACE
  • STRCMP
  • SUBSTR
  • SUBSTRING
  • SUBSTRING_INDEX
  • TO_BASE64
  • TRANSLATE
  • TRIM
  • UCASE, UPPER
• Numeric/Mathematical Functions
  • ABS
  • ACOS
  • ASIN
  • ATAN
  • ATAN2
  • CEIL
  • CONV
  • COS
  • COT
  • CRC32
  • DEGREES
  • DRANDOM, DRAND
  • EXP
  • FLOOR
  • HEX
  • LN
  • LOG2
  • LOG10
  • MOD
  • PI
  • POW, POWER
  • RADIANS
  • RANDOM, RAND
  • ROUND
  • SIGN
  • SIN
  • SQRT
  • TAN
  • TRUNC, TRUNCATE
  • WIDTH_BUCKET
• Date/Time Functions and Operators
  • ADDDATE, DATE_ADD
  • ADDTIME
  • ADD_MONTHS
  • CURDATE, CURRENT_DATE
  • CURRENT_DATETIME, NOW
  • CURTIME, CURRENT_TIME
  • CURRENT_TIMESTAMP, LOCALTIME, LOCALTIMESTAMP
  • DATE
  • DATEDIFF
  • DATE_SUB, SUBDATE
  • DAY, DAYOFMONTH
  • DAYOFWEEK
  • DAYOFYEAR
  • EXTRACT
  • FROM_DAYS
  • FROM_TZ
  • FROM_UNIXTIME
  • HOUR
  • LAST_DAY
  • MAKEDATE
  • MAKETIME
  • MINUTE
  • MONTH
  • MONTHS_BETWEEN
  • NEW_TIME
  • QUARTER
  • ROUND
  • SEC_TO_TIME
  • SECOND
  • SYS_DATE, SYSDATE
  • SYS_DATETIME, SYSDATETIME
  • SYS_TIME, SYSTIME
  • SYS_TIMESTAMP, SYSTIMESTAMP
  • TIME
  • TIME_TO_SEC
  • TIMEDIFF
  • TIMESTAMP
  • TO_DAYS
  • TRUNC
  • TZ_OFFSET
  • UNIX_TIMESTAMP
  • UTC_DATE
  • UTC_TIME
  • WEEK
  • WEEKDAY
  • YEAR
• JSON functions
  • Introduction to JSON functions
  • JSON_ARRAY
  • JSON_OBJECT
  • JSON_KEYS
  • JSON_DEPTH
  • JSON_LENGTH
  • JSON_VALID
  • JSON_TYPE
  • JSON_QUOTE
  • JSON_UNQUOTE
  • JSON_PRETTY
  • JSON_SEARCH
  • JSON_EXTRACT
  • ->
  • ->>
  • JSON_CONTAINS_PATH
  • JSON_CONTAINS
  • JSON_MERGE_PATCH
  • JSON_MERGE_PRESERVE
  • JSON_MERGE
  • JSON_ARRAY_APPEND
  • JSON_ARRAY_INSERT
  • JSON_INSERT
  • JSON_SET
  • JSON_REPLACE
  • JSON_REMOVE
  • JSON_TABLE
• LOB Functions
  • BIT_TO_BLOB
  • BLOB_FROM_FILE
  • BLOB_LENGTH
  • BLOB_TO_BIT
  • CHAR_TO_BLOB
  • CHAR_TO_CLOB
  • CLOB_FROM_FILE
  • CLOB_LENGTH
  • CLOB_TO_CHAR
• Data Type Casting Functions and Operators
  • CAST
  • DATE_FORMAT
  • FORMAT
  • STR_TO_DATE
  • TIME_FORMAT
  • TO_CHAR(date_time)
  • TO_CHAR(number)
  • TO_DATE
  • TO_DATETIME
  • TO_DATETIME_TZ
  • TO_NUMBER
  • TO_TIME
  • TO_TIMESTAMP
  • TO_TIMESTAMP_TZ
• Aggregate/Analytic Functions
  • Overview
  • Aggregate vs. Analytic
  • Analytic functions which “ORDER BY” clause must be specified in OVER function
  • AVG
  • COUNT
  • CUME_DIST
  • DENSE_RANK
  • FIRST_VALUE
  • GROUP_CONCAT
  • LAG
  • LAST_VALUE
  • LEAD
  • MAX
  • MEDIAN
  • MIN
  • NTH_VALUE
  • NTILE
  • PERCENT_RANK
  • PERCENTILE_CONT
  • PERCENTILE_DISC
  • RANK
  • ROW_NUMBER
  • STDDEV, STDDEV_POP
  • STDDEV_SAMP
  • SUM
  • VARIANCE, VAR_POP
  • VAR_SAMP
  • JSON_ARRAYAGG
  • JSON_OBJECTAGG
• Click Counter Functions
  • INCR, DECR
• ROWNUM Functions
  • ROWNUM, INST_NUM
  • ORDERBY_NUM
  • GROUPBY_NUM
• Information Functions
  • CHARSET
  • COERCIBILITY
  • COLLATION
  • CURRENT_USER, USER
  • DATABASE, SCHEMA
  • DBTIMEZONE
  • DEFAULT
  • DISK_SIZE
  • INDEX_CARDINALITY
  • INET_ATON
  • INET_NTOA
  • LAST_INSERT_ID
  • LIST_DBS
  • ROW_COUNT
  • SESSIONTIMEZONE
  • USER, SYSTEM_USER
  • VERSION
• Encryption Function
  • MD5
  • SHA1
  • SHA2
• Comparison Expression
  • Simple Comparison Expression
  • ANY/SOME/ALL quantifiers
  • BETWEEN
  • EXISTS
  • IN
  • IS NULL
  • LIKE
  • REGEXP, RLIKE
  • CASE
• Comparison Functions
  • COALESCE
  • DECODE
  • GREATEST
  • IF
  • IFNULL, NVL
  • ISNULL
  • LEAST
  • NULLIF
  • NVL2
• Other functions
  • SLEEP
  • SYS_GUID