How to convert a String first character in uppercase in oracle

In Oracle INITCAP function sets the first character in each word to uppercase and the rest to lowercase. The syntax for the INITCAP function is: INITCAP(string).

For Example

SELECT INITCAP('SHAHEER') FROM DUAL;

Result: Shaheer

Comments

Popular posts from this blog

How to create Oracle stored Procedures using TOAD for Oracle

Create Tables in Oracle Database using TOAD

How to Create Packages in Oracle Database using TOAD for Oracle