Mega Code Archive

 

Categories / Oracle PLSQL / Data Type

 

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>