Advanced Search

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