SQL - Creating Tables

create table employee

(first varchar(15),

last varchar(20),

age number(3),

address varchar(30),

city varchar(20),

state varchar(20));

Common Data types --

char(size) -- fixed lenght character string

varchar(size) -- variable lenght character string

number(size) -- number value with max number of column digits

date -- date value

number(side, d) -- number value with max digits to right of decimal

create table myemployees_RDP0680                  

(firstname varchar(15),

 lastname varchar(20),

title varchar(30),

age number(3),

salary number(7));