INITCAP

The INITCAP function returns a specified text expression, with the first letter of each word in uppercase and all other letters in lowercase. Words are delimited by white space or characters that are not alphanumeric.

Return Value

The same data type as the expression.

Syntax

INITCAP (text-exp)

Parameters

text-exp: A text expression.

Examples

OLADM1704 Example 7-117 Capitalizing the First Character in Each World

The following example capitalizes each word in the string.

SHOW INITCAP('the soap')  
The Soap

Hide Navigation

Quick Lookup

Database Library · Master Index · Master Glossary · Book List · Data Dictionary · SQL Keywords · Initialization Parameters · Advanced Search · Error Messages

Main Categories

Installation
Getting Started
Administration
Application Development
Grid Computing
High Availability
Data Warehousing
Content Management and Unstructured Data
Information Integration
Security

This Document

Oracle® OLAP DML Reference 11g Release 2 (11.2)
OLAP DML Basic Concepts
Data Types, Operators, and Expressions
Formulas, Models, Aggregations, and Allocations
OLAP DML Properties
OLAP DML Options
OLAP DML Programs
OLAP DML Functions: A - K
OLAP DML Functions: L - Z
OLAP DML Commands: A-G
OLAP DML Commands: H-Z
OLAP_TABLE SQL Functions
DBMS_AW PL/SQL Package
OLAP_API_SESSION_INIT

New and changed documents:

HTML

PDF