Posted By

bbrumm on 02/28/17

Tagged

sql
Oracle

Versions (?)

Last Edited at 02/28/17 05:43am

Statistics

Viewed 899 times

Favorited by 0 user(s)

Related snippets

Oracle LOWER Function

/ Published in: SQL

A few examples of the LOWER function.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

--LOWER
 
--Example 1
SELECT LOWER('Saturday')
FROM dual;
 
 
--Example 2
SELECT LOWER('The city of Houston 2468')
FROM dual;
 
 
--Example 3
SELECT LOWER('ENGLAND')
FROM dual;
 
 
--Example 4
SELECT
first_name,
LOWER(first_name)
FROM customers;