Return to Snippet

Revision: 71059
at December 22, 2016 15:23 by bbrumm


Initial Code
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;

Initial URL
http://www.databasestar.com/oracle-length/

Initial Description
A few examples of the LENGTH function

Initial Title
Oracle LENGTH Function

Initial Tags
sql, Oracle

Initial Language
SQL