테이블

CREATE TABLE 테이블명 ( 컬럼1 데이터타입 [제약조건], 컬럼2 데이터타입 [제약조건], 컬럼3 데이터타입 [제약조건], ... );

DROP TABLE 테이블명;

CREATE TABLE EMPLOYEE ( EMP_ID VARCHAR2(3) PRIMARY KEY, EMP_NAME VARCHAR2(20) NOT NULL, EMP_NO CHAR(14) NOT NULL UNIQUE, EMAIL VARCHAR2(25), PHONE VARCHAR2(12), DEPT_CODE CHAR(2), JOB_CODE CHAR(2) NOT NULL, SALARY NUMBER, BONUS NUMBER, HIRE_DATE DATE DEFAULT SYSDATE );

INSERT INTO EMPLOYEE VALUES ('200', '홍길동', '901010-1234567', 'hong@kh.or.kr', '010-1234-5678', 'D1', 'J1', 3000000, 0.2, SYSDATE);

SELECT * FROM EMPLOYEE;