The following statement uses the INITCAP() function to convert a string to the proper case: SELECT INITCAP( 'hi john' ) FROM DUAL; Code language: SQL (Structured Query Language) ( sql ) The result is as follows:

The syntax for the INITCAP function in Oracle/PLSQL is: INITCAP( string1 ) Parameters or Arguments string1 The string argument whose first character in each word will be converted to uppercase and all remaining characters converted to lowercase.

Jun 2, 2023 · Changing the case of text in SQL is a common task when comparing strings or validating data. Learn how to do it with the UPPER, LOWER, and INITCAP functions in this article. The SQL UPPER function converts a string to upper case. It takes a string input value and converts the characters to uppercase versions of each character.

Aug 5, 2024 · Uses of Oracle INITCAP Function Standardizing Names: Ensures consistent capitalization of names and titles. Formatting Text: Converts text to a standard format with capitalized words.

INITCAP returns char, with the first letter of each word in uppercase, all other letters in lowercase. Words are delimited by white space or characters that are not alphanumeric. char can be of any of the data types CHAR, VARCHAR2, NCHAR, or NVARCHAR2. The return value is …

INITCAP is one of the vital string/char functions of Oracle. It is used to set the first character in each word to UPPERCASE. The rest characters are set to lowercase. The INITCAP function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i.

Apr 5, 2016 · INITCAP returns char, with the first letter of each word in uppercase, all other letters in lowercase. Words are delimited by white space or characters that are not alphanumeric. SELECT INITCAP('the soap') "Capitals" FROM DUAL; Capitals --------- The Soap

Nov 24, 2012 · Oracle INITCAP Function can convert an upper case word to INITCAP. For example, the SQL INITCAP Function query below returns the INITCAP version of the string passed. SELECT INITCAP('TECH HONEY') FROM dual;

INITCAP(x) converts the initial letter of each word in x to uppercase. The following example selects the id and first_name columns, and uses INITCAP() to convert the first letter of each word in first_name to uppercase

Jul 25, 2021 · In Oracle, the INITCAP() function returns its argument with the first letter of each word in uppercase, and all other letters in lowercase. For special linguistic requirements for case conversions, you may want to try the NLS_INITCAP() function instead. The syntax goes like this: