Use string functions in queries

General string functions include the string length calculation function LENGTH(), string truncation function SUBSTR(), string concatenation function, string case conversion functions UPPER() and LOWER(), and string prefix and suffix deletion functions LTRIM(), RTRIM(), and TRIM().

Note that in an Oracle-compatible tenant, the LENGTH() function calculates string lengths in characters and the LENGTHB() function calculates string lengths in bytes, as defined by the character set.

Examples

View the length of the NLS_CHARACTERSET character set.

obclient> SELECT * FROM sys.nls_database_parameters WHERE PARAMETER='NLS_CHARACTERSET';
+------------------+----------+
| PARAMETER        | VALUE    |
+------------------+----------+
| NLS_CHARACTERSET | AL32UTF8 |
+------------------+----------+
1 row in set