INITCAP returns character,
with the first letter of each word in uppercase, all other letters in
lowercase. The following example converts the first letter of the job id column
to uppercase, and the rest to lower case. Note that the values stored in this
table column are all upper case.
Syntax
INITCAP (character)
SQL Statement :
SELECT INITCAP(job_id)
FROM employees;
Output :
No comments:
Post a Comment