Create table: a national char column : National Char « Data Type « Oracle PL / SQL






Create table: a national char column


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>

           
       








Related examples in the same category

1.Use national char set