Mega Code Archive

 

Categories / Oracle PLSQL / Char Functions

 

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>