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>