Oracle SQL - Function UPPER function

  1. HOME
  2. Oracle SQL
  3. Function
  4. UPPER function

Introduction

UPPER function converts every letter in a string to upper-case.

The general format for this function is: 

UPPER(string)

Demo

SQL>
SQL> SELECT UPPER('test') FROM dual ;

UPPE-- from w  w  w. j a v  a2s. c  o m
----
TEST

SQL>