HIT1402 Ref Guide. SingleTable CREATE TABLE

From SwinBrain

SQL to Create Table:

CREATE TABLE Employee (

EmpNo NUMBER(4),

FirstName CHAR(30),

Surname CHAR(30),

Salary NUMBER(8,0),

Gender CHAR(1)

PRIMARY KEY (EmpNo) );

Navigation:
HIT1402