Available in versions: Dev (3.20) | Latest (3.19) | 3.18 | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11 | 3.10
This documentation is for the unreleased development version of jOOQ. Click on the above version links to get this documentation for a supported version of jOOQ.
String functions
Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
String formatting can be done efficiently in the database before returning results to your Java application. As discussed in the chapter about SQL dialects string functions (as any function type) are mostly emulated in your database, in case they are not natively supported.
Table of contents
- 3.11.16.1.
- ASCII
- 3.11.16.2.
- BIN_TO_UUID (new)
- 3.11.16.3.
- BIT_LENGTH
- 3.11.16.4.
- CHR
- 3.11.16.5.
- CONCAT (|| operator)
- 3.11.16.6.
- DIGITS
- 3.11.16.7.
- LEFT
- 3.11.16.8.
- LENGTH
- 3.11.16.9.
- LOWER
- 3.11.16.10.
- LPAD
- 3.11.16.11.
- LTRIM
- 3.11.16.12.
- MD5
- 3.11.16.13.
- MID
- 3.11.16.14.
- OCTET_LENGTH
- 3.11.16.15.
- OVERLAY
- 3.11.16.16.
- POSITION
- 3.11.16.17.
- REGEXP_REPLACE
- 3.11.16.18.
- REPEAT
- 3.11.16.19.
- REPLACE
- 3.11.16.20.
- REVERSE
- 3.11.16.21.
- RIGHT
- 3.11.16.22.
- RPAD
- 3.11.16.23.
- RTRIM
- 3.11.16.24.
- SPACE
- 3.11.16.25.
- SPLIT_PART
- 3.11.16.26.
- SUBSTRING
- 3.11.16.27.
- SUBSTRING_INDEX
- 3.11.16.28.
- TO_CHAR
- 3.11.16.29.
- TO_HEX
- 3.11.16.30.
- TRANSLATE
- 3.11.16.31.
- TRIM
- 3.11.16.32.
- UPPER
- 3.11.16.33.
- UUID
- 3.11.16.34.
- UUID_TO_BIN (new)
| previous : next |
Feedback
Do you have any feedback about this page? We'd love to hear it!