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>