How can convert to only first uppercase letter and other letters lower case in P/L SQL?

Question

I have uppercase word like (NO, YES, FAIL) these word in database column i need to select these column value as No, Yes, Fail(only fist letter uppercase and other letters are lowercase)

is there any in-build function in p/l sql?

Answer 1

Yes, InitCap.

SELECT InitCap( your_column )
  FROM your_table