Length for a char type : Char Length « Char Functions « Oracle PL / SQL

1. Oracle PL / SQL
2. Char Functions
3. 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>
           
       

Related examples in the same category