select initcap('THESE WORDS will be INITcapped') : INITCAP « Char Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Char Functions
  3. INITCAP

select initcap('THESE WORDS will be INITcapped')

 
SQL>
SQL> select initcap('THESE WORDS will be INITcapped')
  2  from dual;
INITCAP('THESEWORDSWILLBEINITC
------------------------------
These Words Will Be Initcapped

1 row selected.

SQL>
SQL> --








Related examples in the same category

1.Initcap: changes the first (initial) letter of a word (string) or series of words into uppercase
2.INITCAP() returns the character string passed into it with the first letter of each word capitalized
3.Simple demo for INITAP: sets the first character in each word to uppercase and the rest to lowercase
4.INITCAP: capital the first letter in a word
5.select initcap( table_name ) from user_tables
6.INITCAP a sentence