Use national char set : National Char « Data Type « Oracle PL / SQL






Use national char set


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;

           
       








Related examples in the same category

1.Create table: a national char column