Functions in SQL

• Data aggregation functions in SQL, such as :
  AVG, COUNT, MAX, MIN, RANGE, SUM, STDDEV, VARIANCE
• Mathematical functions in SQL, such as :
  ABS, CEIL, FLOOR, HEX, MOD, ROUND, SQRT
• String functions in SQL, such as :
  LENGTH, LEFT, RIGHT, SUBSTR, TRIM, VALUE
• Date and time functions in SQL, such as :
  CURRENT, DATE, DAY, EXTEND, MDY, MONTH, WEEKDAY, YEAR
• Other functions in SQL, such as :
  DBSERVERNAME, NVL, SITENAME, USER