'character varying' column : character Unicode « SQL Data Types « Oracle PL/SQL Tutorial






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>
SQL> drop table foo;

Table dropped.








10.5.character Unicode
10.5.1.'character varying' column
10.5.2.'national char' type column