Create a table with number type column: number(4)
SQL> SQL> create table inventory( 2 partno number(4) constraint invent_partno_pk primary key, 3 partdesc varchar2(35) constraint invent_partdesc_uq unique); Table created. SQL> SQL> SQL> drop table inventory; Table dropped. SQL>