• Skip to primary navigation
  • Skip to main content

Tech Honey

The #1 Website for Oracle PL/SQL, OA Framework and HTML

  • Home
  • HTML
    • Tags in HTML
    • HTML Attributes
  • OA Framework
    • Item in OAF
    • Regions in OAF
    • General OAF Topics
  • Oracle
    • statement
    • function
    • clause
    • plsql
    • sql
You are here: Home / Oracle / function / UPPER Function in Oracle SQL – PLSQL

UPPER Function in Oracle SQL – PLSQL

November 24, 2012 by techhoneyadmin

The UPPER Function in Oracle SQL / PLSQL is used to convert the letters of a string to upper case

Syntax for the using the UPPER Function in Oracle SQL / PLSQL is:

SELECT UPPER(string)
FROM table_name;

string is the string whose letters will be converted to UPPER case.

Examples:

Using UPPER Function in Oracle SQL / PLSQL SELECT statement:

SELECT UPPER('Tech Honey')
FROM dual;

Will return ‘TECH HONEY’

SELECT UPPER('tech honey')
FROM dual;

Will return ‘TECH HONEY’

SELECT
UPPER('TECh HOney')
FROM dual;

Will return ‘TECH HONEY’


Filed Under: function Tagged With: how to use UPPER Function in oracle database query, how to use UPPER Function in oracle plsql, how to use UPPER Function in oracle sql, syntax and example of UPPER Function in oracle database query, syntax and example of UPPER Function in oracle plsql, syntax and example of UPPER Function in oracle sql, UPPER Function in oracle plsql, UPPER Function in oracle sql, UPPERPLSQL, using UPPER Function in oracle database query, using UPPER Function in oracle plsql, using UPPER Function in oracle sql

Copyright © 2023 · Parallax Pro on Genesis Framework · WordPress · Log in