🧹 String Functions
SUBSTR, INSTR, REPLACE and padding/trimming helpers for text cleanup.
| Snippet | |
|---|---|
| ☆SUBSTR — Extract a substring |
SELECT SUBSTR(name, 1, 3) FROM employees;
|
| ☆INSTR — Position of a substring (0 if absent) |
SELECT INSTR(name, 'e') FROM employees;
|
| ☆REPLACE — Replace occurrences of a substring |
SELECT REPLACE('abcabc', 'a', '*') FROM dual;
|
| ☆LPAD — Left-pad to a fixed length |
SELECT LPAD('123', 5, '0') FROM dual;
|
| ☆LTRIM / RTRIM — Trim whitespace from both sides |
SELECT LTRIM(RTRIM(' Hello ')) FROM dual;
|