Cacher is the code snippet organizer for pro developers

CREATE USER <username> IDENTIFY BY <password>;
GRANT RESOURCE, CONNECT, CREATEVIEW TO <username>;

CREATE TABLE EMPLOYEE

EMPNAME VARCHAR(2,10),
BASIC NUMBER(10,2),
NET NUMBER(10,2),
PRIMARY KEY EMPNO