But the strings trim can specified ltrim string trim

Table 8.72 Initcap Results
INITCAP_STR
mixed case

Lpad
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.

SELECT ltrim(‘ string’) AS trim_str,
ltrim(‘####string’,’#’) AS single_char_trim, ltrim(‘/**string’,’*/’) AS multi_char_trim FROM dual

Table 8.74 lists the results.

Nls_initcap

INITCAP_STR

Mixed case