sql length

1SELECT length('abcd') FROM DUAL;		-- Oracle
2SELECT length('abcd');					-- MySql / PostGreSQL
3SELECT len('abcd');						-- SQL Server

1-- Relevant for SQL-Oracle only
2
3-- syntax
4LENGTH(<your-string>)
5
6-- example
7LENGTH('CountCharacters') -- OUTPUT: 15
8        123456789012345
9
10-- example with query 
11SELECT 'CountCharacters',LENGTH('CountCharacters')
12FROM DUAL;
13
14-- OUTPUT: CountCharacters, 15

1-- Relevant for MS SQL (SQL Server)
2LEN('string')

1SELECT LENGTH('exemple');