Built-in Functions

The pages that follow discuss the built-in functions for SQLstream streaming SQL.

General Functions

  • ABS
  • ANY
  • AVG
  • CAST
  • CEIL / CEILING
  • CHAR_LENGTH/CHARACTER_LENGTH
  • COALESCE
  • CHAR_TO_TIMESTAMP (SYS_BOOT.MGMT)
  • COALESCE
  • COUNT
  • CURRENT_PATH
  • EVERY
  • EXP
  • EXP_AVG
  • EXTRACT
  • FAST_REGEX_LOG_PARSER
  • FIRST_VALUE
  • FIXED_COLUMN_LOG_PARSE
  • FLOOR
  • GROUP_RANK_UDX
  • INITCAP
  • LAG
  • LAST_VALUE
  • LN
  • LOG10
  • LOWER
  • MAX
  • MIN
  • MOD
  • Monotonic Function
  • NTH_VALUE
  • NULLIF
  • OVERLAY
  • POSITION
  • POWER
  • REGEX_LOG_PARSE
  • REGEX_REPLACE
  • SESSION_USER
  • STDDEV_POP
  • STDDEV_SAMP
  • STEP
  • SUBSTRING
  • SUM

  • SYS_LOG_PARSE

  • SYSTEM_USER

  • TRIM

  • UPPER

  • VAR_POP

  • VAR_SAMP

  • VARIABLE_COLUMN_LOG_PARSE

  • W3C_LOG_PARSE

Time Functions

  • CURRENT_ROW_TIMESTAMP
  • ROWTIME
  • CURRENT_TIME
  • CURRENT_TIMESTAMP
  • CURRENT_DATE
  • LOCALTIME
  • LOCALTIMESTAMP

Datetime Conversion Functions

  • CHAR_TO_DATE
  • CHAR_TO_TIME
  • Char To Timestamp(Sys)
  • DATE_TO_CHAR
  • TIME_TO_CHAR
  • TIMESTAMP_TO_CHAR

General Management Functions

  • GENERATE_DDL_FOR_CATALOG
  • GENERATE_DDL_FOR_JAR
  • GENERATE_DDL_FOR_SCHEMA
  • generate-ddl-for-server
  • GENERATE_DDL_FOR_USER
  • GENERATE_DDL_FOR_WRAPPER
  • GET_OBJECT_DDL
  • GET_KEYWORDS
  • OBJECTS_IN_USE
  • PERFORMANCE_COUNTERS
  • STATEMENTS
  • REPOSITORY_PROPERTIES
  • REPOSITORY_INTEGRITY_VIOLATIONS
  • SESSION_PARAMETERS
  • SESSIONS
  • THREADS
  • SYSTEM_INFO
  • THREAD_STACK_ENTRIES