But the strings trim can specified ltrim string trim
|
|
---|
|
|
|
---|---|---|
|
||
|
Table 8.72 Initcap Results
INITCAP_STR
mixed caseLpad
The lpad function guarantees the length of the string by prefixing characters or trun-cating. By default, spaces are the pad character, but this can be specified.
Oracle SQL | 205 | |||
---|---|---|---|---|
|
DASH_PAD | |||
|
||||
ACCOUNTI | ||||
RESEARCH | ||||
|
|
SALES | ||
OPERATIO |
SELECT ltrim(‘ string’) AS trim_str,
ltrim(‘####string’,’#’) AS single_char_trim, ltrim(‘/**string’,’*/’) AS multi_char_trim FROM dualTable 8.74 lists the results.
Table 8.74 | SINGLE_CHAR_TRIM | MULTI_CHAR_TRIM | |
---|---|---|---|
|
Nls_initcap
INITCAP_STR
Mixed case