Category: >> Oracle PL/SQL >> UPPER function Bookmark and Share

<< lastnext >>

Snippet Name: UPPER function

Description: The upper function converts all letters in the specified string to uppercase.

Also see:
» FUNCTIONS: Deterministic
» FUNCTIONS: Nested Functions
» FUNCTIONS: IF statement
» FUNCTIONS: date/time
» FUNCTIONS: Sample functions
» FUNCTIONS: Recompile
» FUNCTIONS: IN OUT parameter
» FUNCTIONS: with output parameters
» FUNCTIONS: with parameters
» FUNCTIONS: without parameters
» FUNCTIONS: Create function
» FUNCTIONS: special restrictions
» FUNCTIONS: System Privileges
» IN Function
» Built-In Functions: CASE
» Built-In Functions: DECODE
» SUBST and INSTR together
» INSTR (InString)
» SUBSTR (SubString)
» String Functions: REVERSE
» String Functions: LENGTH
» String Functions: INSTR
» String Functions: CONCAT
» String Functions: CHAR
» String Functions: INITCAP
» String Functions: LOWER
» String Functions: UPPER

Comment: If there are characters in the string that are not letters, they are unaffected by this function.

Author: CoderZone
Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: February 28th, 2009

SELECT UPPER 'mayhem' FROM dual;
returns 'MAYHEM'
SELECT UPPER '1mayhem345' FROM dual;
returns '1MAYHEM245'
There haven't been any comments added for this snippet yet. You may add one if you like.  Add a comment 
© | users online: 6