Character Functions
Table 6.1 lists and briefly describes the various character functions.
The INITCAP Function
The INITCAP function is used to modify character values. This function capitalizes the first letter of each set of characters in a character string. The characters following the capitalized character are made lowercase. To illustrate this, Listing 6.1 contains a query that uses this function to capitalize the first letter of two text literals contained in SELECT clause expressions. The initial value of the expression literal is all capital letters. The function modifies this value so that the first character is capitalized, and the remainder are converted to lowercase. The second expression is initially all lowercase characters. The ...
Get Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
