LogoLogo
CtrlK
KORDocs Home
  • Tmax OpenSQL Manual
  • Tmax OpenSQL Overview
  • Tmax OpenSQL Installation
    • Prerequisites
    • OpenSQL 3.0 binary installation
      • Etcd
      • Postgresql
      • Patroni
      • OpenProxy
    • Components configuration
      • Etcd
      • Patroni
      • OpenProxy
  • Tmax OpenSQL Administration
    • Patroni
    • Etcd
      • TLS authentication
    • OpenProxy
      • Connection pool
      • Load balancing
      • Virtual IP and Redundancy
  • Tmax O2 Extensions
    • Architecture Overview
    • Installation
      • O2 Extension Installation
    • Reference guide
      • Type
      • View
      • SQL function
        • Aggregate Functions
          • LISTAGG
          • MEDIAN
          • WM_CONCAT
        • Conditional Functions
          • GREATEST
          • LEAST
          • LNNVL
          • NANVL
          • NVL
          • NVL2
        • DateTime Functions
          • ADD_MONTHS
          • DBTIMEZONE
          • LAST_DAY
          • MONTHS_BETWEEN
          • NEXT_DAY
          • ROUND
          • SESSIONTIMEZONE
          • SYS_EXTRACT_UTC
          • SYSDATE
          • SYSTIMESTAMP
          • TRUNC
        • Format Functions
          • NUMTODSINTERVAL
          • TO_CHAR
          • TO_DATE
          • TO_MULTI_BYTE
          • TO_NUMBER
          • TO_SINGLE_BYTE
          • TO_TIMESTAMP_TZ
          • UNISTR
        • Math Functions
          • BITAND
          • COSH
          • MOD
          • REMAINDER
          • SINH
          • TANH
        • Misc Functions
          • SYS_GUID
          • DUMP
        • Text Functions
          • INSTR
          • LENGTH
          • LPAD
          • LTRIM
          • NLSSORT
          • REGEXP_COUNT
          • REGEXP_INSTR
          • REGEXP_REPLACE
          • REGEXP_LIKE
          • REGEXP_SUBSTR
          • RPAD
          • RTRIM
          • SUBSTR
    • Release Note
      • 1.0
On this page
  • Syntax
  • Overview
  1. Tmax O2 Extensions
  2. Reference guide
  3. SQL function
  4. Text Functions

LENGTH

Syntax

LENGTH(str)

Overview

LENGTH returns the length of the given str.

Parameter

Parameter
Description

str

Arbitrary expression that returns a string. It can have CHAR or TEXT type.

PreviousINSTRNextLPAD

Last updated 1 month ago

© 2025 TmaxTibero, All Rights Reserved.