CREATE TABLE dept ( deptno NUMBER(2) , dname VARCHAR2(14) , loc VARCHAR2(13) );