Oracle PL/SQL/Data Type/National Char

Create table: a national char column

   <source lang="sql">

SQL> SQL> create table foo (

 2         a   integer,
 3         b   dec( 9, 2 ),
 4         c   character varying( 30 ),
 5         d   national char( 3 )
 6  );

Table created. SQL> SQL> SQL> desc foo;

Name                                                                                                  Null?    Type
----------------------------------------------------------------------------------------------------- -------- ----------
A                                                                                                      NUMBER(38)
B                                                                                                      NUMBER(9,2)
C                                                                                                      VARCHAR2(30)
D                                                                                                      NCHAR(3)

SQL> SQL> drop table foo; Table dropped. SQL>

      </source>
   
  

Use national char set

   <source lang="sql">

SQL> SQL> SQL> create table foo (

 2        a   integer,
 3        b   dec( 9, 2 ),
 4        c   character varying( 30 ),
 5        d   national char( 3 )
 6      )
 7      /

Table created. SQL> describe foo

Name                     Null?    Type
------------------------ -------- --------------------------------------------------------------------
A                         NUMBER(38)
B                         NUMBER(9,2)
C                         VARCHAR2(30)
D                         NCHAR(3)

SQL> SQL> drop table foo;

      </source>