Welcome to plsql4all.blogspot.com SQL, MYSQL, ORACLE, TERADATA, MONGODB, MARIADB, GREENPLUM, DB2, POSTGRESQL.

Monday 27 July 2015

ORACLE UPPER FUNCTION

UPPER function in oracle converts all the input characters in upper case.

Syntax :-

SELECT UPPER(INPUT STRING) FROM DUAL;

Example:-

SELECT UPPER('chanchal wankhade') as Upper_exaple from dual;

Result:-  CHANCHAL WANKHADE


Read Also:-UPPER function in SQL

No comments:

Post a Comment

Please provide your feedback in the comments section above. Please don't forget to follow.