The CHAR data type is used for storing fixed-length character strings. : CHAR « Data Type « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Data Type
  3. CHAR

The CHAR data type is used for storing fixed-length character strings.

   
SQL> --
SQL>
SQL> create table MyTable(
  2        bean_name char(50)
  3  );

Table created.

SQL>
SQL> insert into MyTable values( 'A ' );

1 row created.

SQL> insert into MyTable values( ' A' );

1 row created.

SQL> insert into MyTable values( 'A' );

1 row created.

SQL>
SQL> select bean_name, length( bean_name )from MyTable;

BEAN_NAME                                          LENGTH(BEAN_NAME)
-------------------------------------------------- -----------------
A                                                                 50
 A                                                                50
A                                                                 50

SQL>
SQL> drop table MyTable;

Table dropped.

SQL>








Related examples in the same category

1.char type with 50 characters
2.Define varchar2 type variable
3.Comparison of CHAR with VARCHAR2
4.Define and use char value
5.set column width by setting char number
6.CHAR() and VARCHAR2()
7.'' represents a zero length character string BUT NOT a null value
8.No equality comparison between two '' strings
9.Compare char value without knowing the case
10.Convert string to clob
11.char type and varchar2 type
12.Memory allocation differences between the CHAR and VARCHAR2 datatypes