Oracle PL/SQL/Char Functions/Char Length

Length for a char type

SQL>
SQL>
SQL> create table myTable(
  2        bean_name char(50)
  3  );
Table created.
SQL> insert into myTable values( "PPPP" );
1 row created.
SQL> insert into myTable values( "E" );
1 row created.
SQL> insert into myTable values( "S" );
1 row created.
SQL>
SQL> select bean_name, length( bean_name ) from myTable;
BEAN_NAME                                          LENGTH(BEAN_NAME)
-------------------------------------------------- -----------------
PPPP                                                              50
E                                                                 50
S                                                                 50
SQL>
SQL>
SQL> drop table myTable;
Table dropped.
SQL>