Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE table_name ( column_name CHAR(11) );
INSERT INTO table_name ( column_name )
  SELECT 'abcd' FROM DUAL UNION ALL
  SELECT ' abc' FROM DUAL;
2 rows affected

SELECT LENGTH( column_name ),
       LENGTH( TRIM( column_name ) ),
       LENGTH( RTRIM( column_name ) )
FROM   table_name


LENGTH(COLUMN_NAME)
LENGTH(TRIM(COLUMN_NAME))
LENGTH(RTRIM(COLUMN_NAME))


11
4
4

11
3
4