Thanks for fast respone.

For example if we take INITCAP command it will make first letter capitale to all words.

For example.

SELECT INITCAP('the soap') "Capitals" FROM DUAL;

Capitals
---------
The Soap

"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. "

So oracle is recognizing the difference between words in a column by delimiting the spaces.

But i don't know why oracle is not provided any function for this.

Any body have other ideas on this. Any suggestion will help me. Thanks.

Sree.