INITCAP

INITCAP function returns a text expression, wherein it return the first letter of every  word in the string in UPPERCASE and all other letters in lowercase.

Example:

SELECT INITCAP ('oracle world is awesome') FROM DUAL;

Result: Oracle World Is Awesome

Example 2:

SELECT INITCAP (SUBSTR ('oracle world is awesome', 8)) FROM DUAL;

Result: World Is Awesome

 

 

 

 

 

 

Leave a Reply

  • (will not be published)