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;