OracleString FunctionsINITCAP
RPAD

INITCAPString Functions

TRANSLATE

Converts the first letter of each word to uppercase.

Syntax

INITCAP(str)

Example

Enter values below to update the example in real time.

cust_name
name
customers
SELECT INITCAP(LOWER(cust_name)) AS name
FROM customers;