Posted By

bbrumm on 12/22/16

Tagged

sql
Oracle

Versions (?)

Last Edited at 12/22/16 03:23pm

Statistics

Viewed 690 times

Favorited by 0 user(s)

Related snippets

Oracle LENGTH Function

/ Published in: SQL

A few examples of the LENGTH function

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

SELECT LENGTH('Software Developer') AS LENGTH_TEST
FROM dual;
 
SELECT LENGTH('Software Developer     ') AS LENGTH_TEST
FROM dual;
 
SELECT country, LENGTH(country) AS COUNTRY_LENGTH
FROM customers;
 
SELECT LENGTH('') AS LENGTH_EMPTY,
LENGTH(' ') AS LENGTH_SPACE
FROM DUAL;