Mega Code Archive

 

Categories / Oracle PLSQL / Data Type

 

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;