PL/SQL UPPER

The Oracle PL/SQL UPPER function is a string manipulation function that is used to convert a given string to all uppercase letters. The function takes a string as input and returns the same string with all characters in uppercase.

Syntax

The syntax for the UPPER function in PL/SQL is as follows:

UPPER(string)

Here, string is the input string that needs to be converted to uppercase.

Example

Let’s take an example to better understand the usage of the UPPER function:

DECLARE
  my_string VARCHAR2(50) := 'This is a sample string';
BEGIN
  DBMS_OUTPUT.PUT_LINE('Original String: ' || my_string);
  DBMS_OUTPUT.PUT_LINE('Uppercase String: ' || UPPER(my_string));
END;

In this example, we have declared a string my_string and assigned it the value ‘This is a sample string’. We have then used the UPPER function to convert this string to uppercase and display the original and uppercase strings using the DBMS_OUTPUT.PUT_LINE function.

The output of the above PL/SQL block would be:

Original String: This is a sample string
Uppercase String: THIS IS A SAMPLE STRING

As you can see, the UPPER function has successfully converted all characters in the input string to uppercase.

In summary, the Oracle PL/SQL UPPER function is a very useful string manipulation function that can be used to convert a given string to all uppercase letters. This function can be used in a wide range of scenarios where uppercase strings are required, such as in data validation or in formatting output for reports.