O'Reilly logo

Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts by John Adolph Palinski

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required