Mega Code Archive
Create a table with number type column
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>