Mega Code Archive

 

Categories / Oracle PLSQL / Data Type

 

Create table

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>