Use number as the column type
SQL> SQL> create table retired_employees( 2 employee_id number, 3 last_name varchar2(30) 4 ); Table created. SQL> SQL> SQL> drop table retired_employees; Table dropped. SQL>